How to Repalce a Number in a Text

by ashaikh . Updated 17 years, 2 months ago

I am using a table tdpur927900 and field t_consig (which is combo) and value is 1 & 2
I am getting data from SQL table and on the report t_consig display as “1” or “2” ,
I want replace “1” with Spare Parts” and “2” with “Others”.

Can any one help me