syntax error -- Case statement in Query

[dai_lo]

Hi,

I received syntax error for the following statement

SELECT
CASE [File Type]
WHEN 'Security' THEN 'SEC'
WHEN 'Admin' THEN 'ADM'
END AS FT
FROM [tbl_Core Non-Core]


please advise

thanks

Alice

 

[pbaldy]

If you are in Access, then the CASE statement is not valid. You can use the IIf() function in it's place.

 

[KeithG]

You could also try the Switch function.

 

[dai_lo]

SWITCH Function does the work.

many thanks