Thanks!

>Hi Tommy,
>
>If I understood correctly:
>
>

>SELECT icase(intSaletype = 1, 'Sale', intSaletype = 2, 'Return', 'Something else') as SaleType from table
>

>
>
>>Hey Guys.....
>>
>>From my boss....
>>
>>

>>"Can either of you tell me what the syntax is to do a CASE statement in a db lookup, for a fox pro db.
>>
>>This is what it would look like for sql server:
>>
>>SELECT ‘Sale Type’ = CASE intSaletype WHEN 1 THEN ‘Sale’ WHEN 2 THEN ‘Return’ ELSE ‘Something else’ END
>>FROM <table>
>>"
>>

>>Any idea? I am not skilled mssql, so that's why I'm asking you gurus....