Hi, This is a part of my SQL SELECT statement: SELECT IIf([number]>1000,999,[number]) AS Xnumber. How is this done in OQL? Gerard
Take a look at the OQL Case Expression. It allows you to yield different values based on one or more conditions.
Benny van Reeven