Skip to Content
0
Former Member
Dec 06, 2014 at 07:27 AM

PROCEDURE TO REPLACE A CHARACTER ('?') OF A FIELD IN A TABLE WITH A SPACE

25 Views

Hello Experts,

I have been assigned a task where i have 2 tables A and B .

In table A , I have data with some fields and column name Serial No , System , Name and so on...

In column 2 I have a set of entries and for some serial no there is a "?" as a character.

Now i want to replace this character with a space .

The data is uploaded in table A from an excel sheet , This excel sheet is system generated and contains 60000 + entries.

Can you help me write a procedure regarding this ?

Thanks in advance

Thanks and Regards

Aditya Dixit