•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 391,648 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,872 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser:
Views: 484 | Replies: 5 | Solved
 |
•
•
Join Date: Jan 2008
Posts: 3
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Selecting E-mail Addresses I am not a developer or especially knowledgeable in MS SQL, but I am the person responsible for creating special queries for my companies SQL Database. I have a query that is selecting customer names, addresses, product ordered and e-mail addresses. I am want to select only those customers with an e-mail addresses (i.e. JohnSmith@AnyTown.Com). My problem is that the people entering the data aren't consistent in how they record a refusal to give an e-mail address(i.e. "Nope", "N/A", "No", etc.). I know that ALL e-mail addresses have the format USER_NAME@DOMAIN_NAME. I would like the selection criteria to be something like: select when EmailAddress is like "*@*".
Thank you in advance
StageMgrRob
Thank you in advance
StageMgrRob
•
•
Join Date: Nov 2007
Location: Jogja
Posts: 2,383
Reputation:
Rep Power: 9
Solved Threads: 206
SELECT * FROM Customers where EmailAddress like '%" @ "%'"
Never tried = Never Know
So, Please do something before post your thread.
* PM Asking will be ignored *
So, Please do something before post your thread.
* PM Asking will be ignored *
•
•
Join Date: Nov 2007
Location: Bangalore, India
Posts: 3,098
Reputation:
Rep Power: 8
Solved Threads: 238
•
•
•
•
Originally Posted by Jx_Man 
SELECT * FROM Customers where EmailAddress like '%" @ "%'"
Why do we need double quotes around @ ? ("@")
PS. I tried it and it gave me an error.
We can use
SELECT * FROM customers where emailaddresses like '%@%'; Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
*PM asking for help will be ignored*
*PM asking for help will be ignored*
•
•
Join Date: Nov 2007
Location: Jogja
Posts: 2,383
Reputation:
Rep Power: 9
Solved Threads: 206
ah, i'm sorry for this failure. thx for the recovery.
Last edited by Jx_Man : Jan 31st, 2008 at 10:06 am.
Never tried = Never Know
So, Please do something before post your thread.
* PM Asking will be ignored *
So, Please do something before post your thread.
* PM Asking will be ignored *
•
•
Join Date: Jan 2008
Posts: 3
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Thank you all. That is what I was looking for. 
•
•
Join Date: Nov 2007
Location: Jogja
Posts: 2,383
Reputation:
Rep Power: 9
Solved Threads: 206
yeah, you're welcome and thx to nav33n to nice recovery.
don't forget to mark this solved.
All for the best.
don't forget to mark this solved.
All for the best.
Never tried = Never Know
So, Please do something before post your thread.
* PM Asking will be ignored *
So, Please do something before post your thread.
* PM Asking will be ignored *
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
Linear Mode
•
•
•
•
advice ajax asp chain mail collaboration tools daniweb database decimal seperator thousand seperator when using sql server deleting records from ms sql table where columns have duplicate values developer development emai security email misuse gmail hacker mail mail client malware management studio 2005 microsoft msdn news office outlook pop qmail security server smtp software sql sql cache dependency with polling-based invalidation storage survey vista
- Word Association Game (Posting Games)
- Is Stormpay a credible payment system? (eCommerce)
- Update query after cfmail (ColdFusion)
- ALL GMail invites to be posted here please! (Geeks' Lounge)
Other Threads in the MS SQL Forum
- Previous Thread: questions in views and some others
- Next Thread: Help with this Complecated Query
