OraFAQ Forum: Server Administration » Re: who to search patterns ([0-9] or [a-z]) in sql

Home » RDBMS Server » Server Administration » Re: who to search patterns ([0-9] or [a-z]) in sql

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

Re: who to search patterns ([0-9] or [a-z]) in sql [message #372713]

Sun, 04 March 2001 22:20

jimmy
Messages: 21
Registered: November 2000

Junior Member

I'm only a college student, so you'll forgive me if I'm wrong, but I think the SQL syntax you are
looking for is something like this:

SELECT column_name
FROM table_name
WHERE column_name LIKE 'S00_'
AND column_name IN ('S00A','SOOB','SOOC',...etc);

You've probably alreadly came up this one and was looking for something way more efficient and less of a hassle to write.

Hope that helped.

Report message to a moderator

Re: who to search patterns ([0-9] or [a-z]) in sql [message #372714 is a reply to message #372713]

Sun, 04 March 2001 23:59

vinay
Messages: 27
Registered: December 1999

Junior Member

Hi,

WHERE column_name LIKE 'S00_'
AND column_name IN ('S00A','SOOB','SOOC',...etc);

Above syntax works but here I need to give all combinations ('S00A','S00B',....,'S00Z')

Is there better way of doing this

Thanks for the reply

Report message to a moderator

Previous Topic:	HOW TO CONVERT NUMBER TO WORD FORMAT WHERE NUMBER HAVING MORE THEN 5373484
Next Topic:	sure this will work as per babu's view.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 09 07:51:06 CST 2025