case statement in a select? 1

[ronaldmacdonald]

Hi

I am wondering if its possible to use a case statement in a select query. For example I have a field that contains 3 possible values A,B or C. As I select these fields I want to display a different value as thus:

A = X
B = Y
C = Z

I thought something like:

SELECT 'status' = CASE WHEN Field = 'A' THEN 'X' WHEN Field = 'B' THEN 'Y' WHEN Field = 'C' THEN 'Z' END)

But this doesnt seem to work?

 

[john76]

Try this:

Select  Status = Case Field When 'A' Then 'X' When 'B' Then 'Y' When 'C' Then 'Z' End

HTH,
John

 

[ronaldmacdonald]

Cool john76 - dis the job perfectly - thanks!