IIf Condition in sql server

[Guest_imported]

I have tried the following IIf query which is not working

iif(ID_LEVEL='0','1',reverse(substring(reverse(ID_LEVEL),charindex('.',reverse(ID_LEVEL))+1,LEN(ID_LEVEL))) which does not work. Can anybody teel me the right syntax as it gives a syntax error.

if id_level is 0 then return 1 else execute the query :
reverse(substring(reverse(ID_LEVEL),charindex('.',reverse(ID_LEVEL))+1,LEN(ID_LEVEL))

 

[tlbroadbent]

There is no IIf in SQL Server. Use the CASE statement instead.

Case ID_LEVEL
When '0' Then '1'
Else reverse(substring(reverse(ID_LEVEL),charindex('.',reverse(ID_LEVEL))+1,LEN(ID_LEVEL)))
End Terry L. Broadbent
Life would be easier if I had the source code. -Anonymous