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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 quick question ..

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
Go to Top of Page

berengar
Starting Member

21 Posts

Posted - 2008-10-07 : 12:23:49
Thanks .. just got it !!

Go to Top of Page
   

- Advertisement -