To pull all emails that contains +,^,*,&,!

•

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 374,005 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,778 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.

Join our community!

Please support our MS SQL advertiser:

Thread Tools Display Modes

Views: 537 | Replies: 2 | Solved

•

Join Date: Apr 2008

Posts: 18

Reputation: mansi sharma is an unknown quantity at this point

Rep Power: 1

Solved Threads: 0

mansi sharma mansi sharma is offline

Offline

Newbie Poster

**To pull all emails that contains +,^,*,&,!**

Apr 9th, 2008

--Que-4)Create a Query to pull all emails that contains
--characters +,^,*,&,!

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
CREATE TABLE mail3(email varchar(50))
INSERT INTO mail3 VALUES('mansi.sharma@yahoo.co.in')
INSERT INTO mail3 VALUES('mansi.sharma+yahoo.co.in')
INSERT INTO mail3 VALUES('mansi.sharma^yahoo.co.in')
INSERT INTO mail3 VALUES('mansi.sharma*yahoo.co.in')
INSERT INTO mail3 VALUES('mansi.sharma&yahoo.co.in')
INSERT INTO mail3 VALUES('mansi.sharma!yahoo.co.in')
INSERT INTO mail3 VALUES('mansi&sharma!yahoo.co.in')
SELECT * FROM mail3
create table mail3(email varchar(50))
insert into mail3 values('mansi.sharma@yahoo.co.in')
insert into mail3 values('mansi.sharma+yahoo.co.in')
insert into mail3 values('mansi.sharma^yahoo.co.in')
insert into mail3 values('mansi.sharma*yahoo.co.in')
insert into mail3 values('mansi.sharma&yahoo.co.in')
insert into mail3 values('mansi.sharma!yahoo.co.in')
insert into mail3 values('mansi&sharma!yahoo.co.in')
select * from mail3

select * from mail3 where email like '%+%' or '%*%'

I have tried the above query but error is coming. Reply .thx in advance.

Last edited by peter_budo : Apr 10th, 2008 at 4:24 pm. Reason: Keep It Organized - please use [code] tags

•

Join Date: Feb 2008

Posts: 14

Reputation: huangzhi is an unknown quantity at this point

Rep Power: 1

Solved Threads: 4

huangzhi

Offline

Newbie Poster

**Re: To pull all emails that contains +,^,*,&,!**

Apr 10th, 2008

The correct code is:

select * from mail3 where email like '%+%' or email like '%*%'

Last edited by peter_budo : Apr 10th, 2008 at 4:24 pm. Reason: Keep It Organized - please use [code] tags

Hence Wijaya
www.ex-Soft.tk

•

Join Date: Apr 2008

Posts: 18

Reputation: mansi sharma is an unknown quantity at this point

Rep Power: 1

Solved Threads: 0

mansi sharma mansi sharma is offline

Offline

Newbie Poster

**Re: To pull all emails that contains +,^,*,&,!**

Apr 10th, 2008

Thx,It worked.
Plz see the following query-

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
SELECT * FROM mail3 
WHERE email NOT LIKE '%@%' 
OR email NOT LIKE '%&%'
SELECT * FROM mail3 
WHERE email NOT LIKE '%@%' 
or email not like '%&%'

Instead of showing the particular records ,the above query is displaying all the records.

Last edited by peter_budo : Apr 10th, 2008 at 4:24 pm. Reason: Keep It Organized - please use [code] tags

•

Only community members can participate in forum threads. You must register or log in to contribute.

•

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

•

DaniWeb MS SQL Marketplace

•

Thread Tools	Display Modes
Show Printable Version Email this Page	Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Other Threads in the MS SQL Forum

Previous Thread: Urgent Help Needed
Next Thread: Link server in MS SQL 2005

DaniWeb Home > Forums > Web Development > Databases > MS SQL

To pull all emails that contains +,^,*,&,!

To pull all emails that contains +,^,*,&,!

Re: To pull all emails that contains +,^,*,&,!

Re: To pull all emails that contains +,^,*,&,!

**To pull all emails that contains +,^,*,&,!**

**Re: To pull all emails that contains +,^,*,&,!**

**Re: To pull all emails that contains +,^,*,&,!**