REMOVING SPECIAL CHARACTERS FROM A STRING

SUMAN CHILUVURI · Post by **SUMAN CHILUVURI** » Mon Apr 11, 2011 9:50 am

I NEED TO REMOVE SPECIAL CHARACTERS FROM THE STRING

EXAMPLE --- (732) 556-6677

RESULT --- 7325566677

CAN ANY ONE SUGGEST ME HOW TO DO IT AND PLEASE GIVE ME THE SYNTAX

chulett · Post by **chulett** » Mon Apr 11, 2011 9:57 am

Please don't post in all caps, it is considered SHOUTING.

Now... are the only "special" characters you need to remove the ones you posted in your example? If so, the Convert() function will handle that easily.

vinothkumar · Post by **vinothkumar** » Mon Apr 11, 2011 9:58 am

Use CONVERT function. And this has been answered here already. You can do a serach in this forum also.