If VFP, I can have below statement:

Select IIf(group = 1,'A','B') As sorter, amount From table1 

Is this possible in SQL Server T-SQL? Actually, I tried it but it gives me an error. Or I am just missing something?

TIA