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 |
|
asifbhura
Posting Yak Master
165 Posts |
 Posted - 2006-10-07 : 16:29:00
|
| hii have emailid field in table.I want all emailid which is having 3 or less than 3 character as maillid means before @ character.please help mewaiting for reply |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2006-10-07 : 16:32:58
|
SELECT emailidFROM YourtableWHERE CHARINDEX('@', emailid) <= 3Duane.  |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-09 : 03:57:51
|
| 1) If maximum three characters are allowed before @, doesn't that mean that @ is the fourth character?2) What if there are no @ at all?WHERE CHARINDEX('@', EmailID) BETWEEN 1 AND 4Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
want to have all emailid ....