Multiple Values in Like Statement 1

[nickotine]

Help Please.
I am trying to insert Multiple values in a LIKE statement, I.e.

select object, bin
from ourhouse t
where t.rowid = :rowid
and bin = '*'
and store like ('EL%','TA%')

I keep getting a message saying Missing Right Parenthesis.

Thanks in advance.

 

[sem]

You may compare only against single format mask. Use OR instead.

select  object, bin
from ourhouse t 
where t.rowid = :rowid
and bin  = '*'
and (store like 'EL%' or store like 'TA%')

This is a common rule, but your specific case may be rewritten as:

select  object, bin
from ourhouse t 
where t.rowid = :rowid
and bin  = '*'
and substr(store,1,2) in ('EL','TA')

Regards, Dima

http://seminihin.narod.ru