Go thru this link,

http://www.eggheadcafe.com/PrintSearchContent.asp?LINKID=529

It uses table variable & While loop to handle this scenario..... I would suggest to go for this only if ur record count is small.... or...

Its better not u use such type of 3rd party products, I cannot even beleive that its creating so much ad-hoc tables and not deleting it... then why do we...

Thats great peice of infrm....... I tried it in inner query & Sql is not picking it....

Try This......

UPDATE EMPLOYEE SET SIGN_ON  = REPLACE(SIGN_ON ,'''','')

WHERE SIGN_ON  LIKE '%''%'

Sree

This is quite interesting .... I would say plsssss check once again......... This will never happen...