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

Tue, 06 March 2001 11:56

laxmi
Messages: 9
Registered: December 2000

Junior Member

Try this:
select col3 from table
where substr(column ,4) between chr(65) and chr(90);

for lower case (a-z):between chr(97) and chr(122)

Previous Topic:	retriving particular rows in order
Next Topic:	Re: who to search patterns ([0-9] or [a-z]) in sql

Goto Forum:

]

Current Time: Sat Jun 29 13:28:10 CDT 2024