Jackson,
You can use your RDBMS to return special characters. You just need to find out the numeric value of them. For example, to get the Tab character, Set Fields SQL: SELECT CHAR(9) Once you have the value in a character field you can use that for your replacing. HTH Stephen Remedy Skilled Professional ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jack Samson Sent: Wednesday, October 31, 2007 4:19 PM To: [email protected] Subject: Re: Replace function on a special character Hi All, I am using ARS version 6.3 and am trying to perform a REPLACE() function using a filter. I have a few special characters that I can see using a hex editor and the editor gives me the hex equivalent. My question is how do I perform a replace on a special character? Thanks, Jackson ________________________________ Boo! Scare away worms, viruses and so much more! Try Windows Live OneCare! Try now! <http://onecare.live.com/standard/en-us/purchase/trial.aspx?s_cid=wl_hot mailnews> __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
