SELECT statement

[RobColborne]

Hi

Using MSSQL 7.

I have a column called CODE containing a 3-letter code, e.g. SUC.

I would like to do a simple SELECT statement but return SUCESSFUL where CODE = SUC rather than SUC.

Can this be done?

Thanks
Rob

 

[srogers]

How about a CASE statement like this:

select
CASE CODE
WHEN 'SUC' THEN 'Successful'
ELSE CODE
END as 'Full Word'
from TableName

Hope that helps.
Sharon

 

[RobColborne]

Thanks Sharon, Thats just what I wanted!

R