>>>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"

I tried that and it didn't seem to work. But when using the same idea as above for the number that fixed the problem.

"<"pre">"

SELECT *, ;
IIF( INLIST( cUserSecurityLevel,'A','B', 'C' ), cUserSecurityLevel+' ', 'ZZ' ) AS ; cUserLvl ;
FROM ;
UserSecurity