>>I want to have an SQL statement that will allow an IIF that can accept up to 2 digits.
>>
>>
>>
>>SELECT *, ;
>> IIF( INLIST( nUserSecurityLevel, 1, 2, 3 ), nUserSecurityLevel+00, 99 ) AS ; nUserLvl ;
>> FROM ;
>> UserSecurity
>>
>>
>>Excellent. Thank you for your 34 second response :).
>>
>>Dan
>
>Sorry about the blank post.. How would I handle it if the above used characters instead.
>'A', 'B', 'C' and "ZZ".
>
>Dan
'A ', 'B ', 'C ' and "ZZ"
Edward Pikman
Independent Consultant