My table has the below data
01 Harley Davison
When I give a select query, I want to display the vehicle type instead of the numbers like shown below . is it possible ? is there any option available ? Can Replace function be used ?
Select VehicleNo, VehicleName from Vehicle ;
MC Harley Davison
01 Should be replaced by MC, 02 should be replaced by CAR, 03 should be replaced by BUS.
Note: The table should not be updated, Only on the select query output it should display in the shown format.
if possible, please help.