Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-09-13 : 00:30:08
|
| Ashu writes " I m trying the following query which does not work :iif(ID_LEVEL='0','1',reverse(substring(reverse(ID_LEVEL),charindex('.',reverse(ID_LEVEL))+1,LEN(ID_LEVEL))) ID_LEVEL is a column name If ID_LEVEL is 0 it should return 1 else it should execute the query : reverse(substring(reverse(ID_LEVEL),charindex('.',reverse(ID_LEVEL))+1,LEN(ID_LEVEL)) It gives me a syntax error. Can anybody tell me what is the problem. " |
|
|
|
|
|
IIf condition not working