Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-16 : 08:51:47
|
| alpesh shah writes "in my phone field i have phone number stored as 1234567890 where, 123 is an area code and 4567890 is the number. what i want is, i want ( ) around the area code and - in between the phone number. How do I do this in sql? Do I have to write a store procedure or is this a design issue? Please let me know. I appreciate your help in advanced.ThanksAlpesh Shah" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-08-16 : 09:17:51
|
| Various string functions are described in depth in Books Online. Look up LEFT, RIGHT, LEN, SUBSTRING, STUFF and the like.This is probably not a design issue and your probably should write a store procedure for all you interaction with the data tier.Jay White{0} |
 |
|
|
|
|
|
sql database field