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 |
|
berengar
Starting Member
21 Posts |
Posted - 2008-10-07 : 12:17:30
|
| Hi I forget the function for returning the postion of a character in a string, for example if i want the @ in abc@xyz.com it will return 4 .. |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2008-10-07 : 12:22:20
|
| [code]SELECT CHARINDEX('@', 'abcd@fg')[/code]-------------Charlie |
 |
|
|
berengar
Starting Member
21 Posts |
Posted - 2008-10-07 : 12:23:49
|
| Thanks .. just got it !! |
 |
|
|
|
|
|