query and data display 1

[Taxidriver]

Would it be possible to do a query with

select dettaglio.Idtipo as c200_c201 from etc etc

and instead of displaying 1 or 2 (the possible values of idtipo) C201 if the value is 1 and C200 if the value is 2.

 

[Katy44]

Look at using the SQL Server case statement.