LinkBack URL
About LinkBacksIs there a way to use case functionality in MSQuery like in tsql.
Example
Select Job,
Case trantype
when 1 then amount
when 2 then amount *-1
end as Amt
from tblJob
Is there a way to use case functionality in MSQuery like in tsql.
Example
Select Job,
Case trantype
when 1 then amount
when 2 then amount *-1
end as Amt
from tblJob
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks