arrgent please

how can i remove \r (escape) from my data base.
Hi
Assuming this is ascii character value 18 and a single column in a given
table try something like:
/* Sample Data */
CREATE TABLE #temp ( charfld varchar(20))
INSERT INTO #temp ( charfld )
SELECT 'ABC' + CHAR(18)
UNION ALL SELECT 'DEF' + CHAR(18) + 'GHI'
UNION ALL SELECT 'JKL'
SELECT * FROM #temp
/* Sample update - change to be your table */
UPDATE #temp
SET charfld = REPLACE(charfld,char(18),'')
WHERE CHARINDEX(CHAR(18),charfld) > 0
SELECT * FROM #temp
John
"sanjay" <sanjay.pareek.in@.gmail.com> wrote in message
news:1136638292.582365.56360@.g47g2000cwa.googlegro ups.com...
> how can i remove \r (escape) from my data base.
>