> 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
procedure.


HTH,
Thomas Steinmaurer

The IB LogManager Product Family
Logging/Auditing Suite for InterBase and Firebird
http://www.iblogmanager.com