This is a case for
Case
. See Microsoft documentation for
Case (Transact SQL)[
^]
If Gender is a numeric data type:
Select TOP 1000 ID,Num,FirstName,Nickname,LastName, Case Gender When 0 Then 'Male' When 1 Then 'Female' Else 'N/A' End As Gender FROM TravelAgency.dbo.CustomersViews
If Gender is a character data type:
Select TOP 1000 ID,Num,FirstName,Nickname,LastName, Case Gender When '0' Then 'Male' When '1' Then 'Female' Else 'N/A' End As Gender FROM TravelAgency.dbo.CustomersViews