Subject RE: [firebird-support] Correct syntax of a view, please.
Author Thomas Steinmaurer
> Can anyone point me in the direction to the correct syntax of a view
> like:
> select aNr,aName,aText ,
> ---> (1 if aNr mod 10 = 0, 0 otherwise) <---- this line please
> from MyTable

If you are using Firebird 1.5 then have a look at the CASE
statement. Prior 1.5 you have to write a SELECTable stored

Thomas Steinmaurer

The IB LogManager Product Family
Logging/Auditing Suite for InterBase and Firebird