Question Locked

How to Repalce a Number in a Text

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

aamir

2 replies

by mohamed noaman

select
case when t_consig = 1 then 'Spare Parts'
when t_consig = 2 then 'Others'
end as t_consig
from tdpur927900

i wish this is the query you need
if not pls. put more description for the qry. u need

This discussion is closed to new replies.