I have done this in the past with SQL Server and it works on IB7, but does not work on IB6. Can someone help me with the correct method to do this in IB6?
I have:
select field1,
(case field2 when 1 then 'Text1'
when 2 then 'Text2'
when 3 then 'Text3'
else 'Text4'),
field3
from .......
The case statement does not seem to be supported in IB6. I tried replacing it with an "if" statement, but that does not seem to be supported within the select statement.
Hoping someone can help.
Thanks.
I have:
select field1,
(case field2 when 1 then 'Text1'
when 2 then 'Text2'
when 3 then 'Text3'
else 'Text4'),
field3
from .......
The case statement does not seem to be supported in IB6. I tried replacing it with an "if" statement, but that does not seem to be supported within the select statement.
Hoping someone can help.
Thanks.