DSXchange

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

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.

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