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