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 |
|
khusiie
Yak Posting Veteran
78 Posts |
 Posted - 2009-09-08 : 11:45:11
|
| i want colum who has email-address.select id, email from testmailwhere email like '%@%'is it correct way? as i m not any results..can anyone tell me what's the correct way to get email-address field.thanks |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2009-09-08 : 13:13:15
|
| There is nothing wrong with your code. Maybe there are no matching rows. Post some values from [testmail].[email] that you expect to be returned.ie:select top 10 email from testmailBe One with the OptimizerTG |
 |
|
|
|
|
|
email-address