Update

[annub]

One of the col in my table is nvarchar datatype & data is something like this. PQ1234,PQ34566,PQ1111. I want to remove PQ's from data. How do i update this col.

Thanks

 

[Jamfool]

update table_name set column_name = replace(column_name,'PQ','')

 

[mwolf00]

UPDATE myTable set myCol = replace(myCol,'PQ','')

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook (No, I'm not Rick)

 

[mwolf00]

Whew - that was fast Jamfool...

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook (No, I'm not Rick)

 

[MatthewPeters]

Try this . . .

update tbl set fld = substring(fld, 3, len(fld)-2)

Matt