SQL search and replace text char 1

[Minimorgie]

Hi,
I'm trying to write a sql script for sql server that searches a table column for a char and replaces it with either null or space. I can only find how to do this if the char is in a known position and unfortunately it will not always be. Any advice (explained as simply as possible!), would be welcomed.

Thanks
Minimorgie

 

[hmckillop]

Have a look at the REPLACE function

i.e. to replace the character 'C' with '' in the column ColumnA in a table MYTable you would use code

UPDATE MyTable
SET ColumnA = REPLACE(ColumnA, 'C', '')

"I'm living so far beyond my income that we may almost be said to be living apart