*** create the data CREATE CURSOR test (nTest n(3)) INSERT into test VALUES (1) INSERT into test VALUES (99) INSERT into test VALUES (100)And then this select statement.
SELECT IIF(nTest>99,ntest,099) ntest FROM testIt returns 3 records.
Ntest 99 99 100NOTE that you need the value 099 because that forces the result to 3 digits.