Stephen, Thank you for the information. Is their a chart that gives a conversion for each character? I looked at the ASCII table and was not sure how to convert it from this to a CHAR(9). I have a line feed or a hex of 0A. What would give me the equivalent in the SELECT CHAR(<What would this be for 0A>). Once I know the value I then want to remove this character from the string. Regards, Jackson
Date: Wed, 31 Oct 2007 16:22:56 -0400From: [EMAIL PROTECTED]: Re: Replace function on a special characterTo: [EMAIL PROTECTED] 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 SamsonSent: Wednesday, October 31, 2007 4:19 PMTo: [EMAIL PROTECTED]: 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!__20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ _________________________________________________________________ Windows Live Hotmail and Microsoft Office Outlook – together at last. Get it now. http://office.microsoft.com/en-us/outlook/HA102225181033.aspx?pid=CL100626971033 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
