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 |
|
13ina
Starting Member
5 Posts |
 Posted - 2009-10-27 : 20:17:02
|
| I'm a complete newbie to MS SQL, and I really need to take an email field from a table, split it, and display it within the results as three parts. Does anyone know how I could do this? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-10-27 : 21:36:21
|
how do you want to split the email ?you can check out charindex(), left(), substring(), right() etc in the Books Online. These are the basic functions you need for string parsing.
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
13ina
Starting Member
5 Posts |
Posted - 2009-10-29 : 12:40:09
|
| I want to split it into three. For example:If I give you binak@gmail.com. It would become- binak- gmail- com |
|
|
|
|
|
|
Splitting String Data MS SQL