how to get index of in sql server? Ask Question
Solutions
Nawab
You get this by using LEFT and CHARINDEX
SELECT LEFT('abcd@abc.com, CHARINDEX('@', 'abcd@abc.com') - 1) AS username
I have an field with name email like "abcd@abc.com"
I want to get first text of @ which is "abcd" and set it into another field username.
You get this by using LEFT and CHARINDEX
SELECT LEFT('abcd@abc.com, CHARINDEX('@', 'abcd@abc.com') - 1) AS username
Enter an email address to invite a colleague or co-author to join you on socimo. They will receive an email and, in some cases, up to two reminders.