>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