Ultralite does not support any procedural language including stored procedures or functions or triggers, so there is no support for, nor need of, if statements. But if you are wanting to use an "if" within an expression then, yes, Ultralite supports if expressions. The basic syntax of an if expression is: IF search-condition THEN expression1 [ ELSE expression2 ] ENDIF Example: select IF @foo = @bar THEN 1 ELSE 0 ENDIF as X from T See the documentation for more information. answered 28 May '13, 21:31 Mark Culp Thank you!
(29 May '13, 09:15)
Peng84
Replies hidden
If that answer has helped you, you're invited to mark it as accepted - cf. How do I accept an answer to my question?
(29 May '13, 09:21)
Volker Barth
|