OraFAQ Forum: Server Administration » WHERE clause with multiple LIKE entries

Home » RDBMS Server » Server Administration » WHERE clause with multiple LIKE entries

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

WHERE clause with multiple LIKE entries [message #374291]

Mon, 04 June 2001 18:09

Carl Colburn
Messages: 7
Registered: June 2001

Junior Member

Hi,
Have VB6 app working on Oracle 8.
Two questions:

1. How do you specify numerical values in a "like" statement when searching on wildcards. For example, if I have data values:

ABCWWWWW
ABC11111
ABC22222
ABC33333

I would like to select all values that are ABC followed by numbers, not letters. Such as "...WHERE type like 'ABC%'", but need % to reference any number but not any letter.

2. I need to write a WHERE clause in my SELECT statement that searches for multiple "LIKE" values. For example, all values that start with "ABC1%" and "ABC2%", but not "ABC3%".

"...WHERE type like 'ABC1%' OR 'ABC2%'".
"...WHERE type in (like 'ABC1%', 'ABC2%')

I know this syntax doesn't work, but shows what I need to do.

Thanks in advance.

Report message to a moderator

Previous Topic:	create view
Next Topic:	WHERE clause with multiple LIKE entries

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 12:59:33 CST 2024