Multiple Like SQL Command

Question

I have this query:

 select * from m3fdbprd.cmnusr
 where juultp = 1
 and jutx40 <> LIKE 'M3%' OR jutx40 <> LIKE 'MeC%'
 order by jutx40

I am getting an error:

SQL0104 - Token 'M3%' was not valid. Valid tokens: FOR USE SKIP WAIT WITH FETCH LIMIT ORDER UNION EXCEPT OFFSET.

where I am trying to do a multiple like, I am running this query to display all values in m3fdbprd.cmnusr where in the column jutx40 the value does not start with M3 or Mec.

Can you please advise?

I am running against an MS sql server database.

SQL0104 does not looks like a SQL Server error message. Googling shows that is is more likely DB2 — Squirrel
– Squirrel, Commented Apr 3, 2018 at 11:17

Gordon Linoff · Accepted Answer · 2018-04-03 11:12:29Z

5

Use NOT LIKE. I'm also pretty sure you want AND and not OR:

select *
from m3fdbprd.cmnusr
where juultp = 1 and
      jutx40 not like 'M3%' and jutx40 not LIKE 'MeC%'
order by jutx40

answered Apr 3, 2018 at 11:12

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Whencesoever · Accepted Answer · 2018-04-03 11:12:48Z

2

You should use NOT instead of <>

 select * from m3fdbprd.cmnusr
 where juultp = 1
 and jutx40 NOT LIKE 'M3%' OR jutx40 NOT LIKE 'MeC%'
 order by jutx40

answered Apr 3, 2018 at 11:12

Whencesoever

2,30617 silver badges26 bronze badges

Comments

MatSnow · Accepted Answer · 2018-04-03 11:22:28Z

0

Another approach is to use NOT with parentheses:

SELECT * FROM m3fdbprd.cmnusr
WHERE juultp = 1
AND NOT (jutx40 LIKE 'M3%' OR jutx40 LIKE 'MeC%')
ORDER BY jutx40

answered Apr 3, 2018 at 11:22

MatSnow

7,5573 gold badges22 silver badges32 bronze badges

Collectives™ on Stack Overflow

Multiple Like SQL Command

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related