Tunkster
asked on
iif statement/derived field in SQL
I am using a report writer that queries SQL tables and I am trying to create a derived field. If a field w/in the table equals one value then give x result fior this derived field, if the field equals another then have the derived field give a diff. result, etc...
Is there a way to do that in SQL.
Thx.
Is there a way to do that in SQL.
Thx.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I stand corrected:
case (BSOL9.dbo.TW70800.TW_User _Def_text_ 5)
when '8810' then '8810!'
else 'nope'
end
Worked... THX!
case (BSOL9.dbo.TW70800.TW_User
when '8810' then '8810!'
else 'nope'
end
Worked... THX!
ASKER
The Case scenario is more of a function that I can not define into a derived field per se...