How to eliminate Special characters

satheesh_color · Post by **satheesh_color** » Wed Mar 28, 2007 5:03 am

Hi All,

I have a DB column name Product_long_name..it contains special characters or non printable characters.how can i eliminate the special characters other than ascii values 0--to--128...can you give me a resolution on this.

Thanks & Regards,
Satheesh.R

thurmy34 · Post by **thurmy34** » Wed Mar 28, 2007 6:53 am

Hi
You can use the oconv function like this

Code: Select all

X = Oconv("John^CSmith^X1-234", "MCP")

ray.wurlod · Post by **ray.wurlod** » Wed Mar 28, 2007 7:08 am

Technical Note

128 is not an ASCII character. ASCII is a seven-bit encoding, which allows only 0 through 127.