Update problem

ankur02018 · #1 (**permalink**) 02-23-09, 06:27

Hi ,
I want to update column such that

If column consist

JOBDESC=Resolve user queries post Go â?? Live

I want to update only â?? to space

A query such that where find â?? in that column replace with space?

mike_bike_kite · #2 (**permalink**) 02-23-09, 06:34

Something like this might work :

Code:

update YourTable 
set    YourColumn = REPLACE( YourColumn , 'â??' , ' ' )
where  YourColumn like '%â??%'

Just not sure whether you can use the string just like that.

Internet Services

Web Development

Digital Marketing

Consumer Tech