Help needed

T

telukunta.vikas

Hi All..

Could some one help me with this issue..

I am working on a SQLServer database as backend for my Visual Studio
2005.

I have a phone number field in a table.
The phone number filed looks like this-->>

2175574696 which is a text field.

I would like to change the format to -->> (217)557-4696

Could some one plz help me in it. Just give me the SQL Quesry which can
change the format to desired format.

Thanks All n waiting for ur posts..
Regards..
Vikas
 
S

SusanV

You should be formatting this on the form or report users will view it on -
no need to format the raw data in the table.
 
Top