Incorrect syntax near the keyword 'CASE'

[former_member859179]

So I'm trying to learn conditional commands but this is happening in SSMS on MSQL Server 2019

Also Same thing happens when I use Extract Command

Sorry I wrote currency name instead I want AS currencysymbol eveything else is good.

[SonTran · Accepted solution]

Hi,

You missed the "," between "*" and "CASE"

Hope this helps,

Son Tran