SQL Query?

[sc5502]

I have a SQL table with a field that has a length of 1. The field is named Status and has a value of I (inactive) or A (active). Status varchar(1). I want to show either Inactive or Active instead of just an I or A. Is this possible?

[GazMathias]

Sure,

Take a look at the Case expression.

SELECT CASE [Status] WHEN 'I' THEN 'Inactive' ELSE 'Active' END AS [Status] FROM [Your table name]

Gaz

[sc5502]

Thank you very much.