I have not used before, but I have to change an access query in SQL so that I can write a report in crystal. / P>
The query currently uses its selection statement in the IFF function, which determines what value will be returned based on the value of the table for a particular column.
For example, if the value is "CR" should be returned as "credit" and if it is "NCR" then it should be returned as "non-credit"
Can I do something in SQL?
Use an expression. When some column = 'CR' then 'credit' when some column = 'NCR' then 'non-credit' end Html>
Comments
Post a Comment