DECODE( ) function in SQL Server
If I understand the question correctly, you want the equivalent of decode but in T-SQL
Select YourFieldAliasName =
CASE PC_SL_LDGR_CODE
WHEN '02' THEN 'DR'
ELSE 'CR'
END
You could use the 'CASE .. WHEN .. THEN .. ELSE .. END' syntax in SQL.