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


SELECT IIF(condition=.T.,PADL(ALLT(field),2),"ZZ") AS newfield.