Home » RDBMS Server » Server Administration » Re: who to search patterns ([0-9] or [a-z]) in sql
Re: who to search patterns ([0-9] or [a-z]) in sql [message #373687] Tue, 01 May 2001 15:54
jacob
Messages: 6
Registered: October 2000
Junior Member
SELECT ENAME FROM T11 WHERE SUBSTR(ENAME,5) BETWEEN 'A' AND 'Z' ORDER BY SUBSTR(ENAME,5)
Previous Topic: what is the diff between -select table_name from all_tables;and select * from tab?
Next Topic: simple sql statement - performance issue
Goto Forum:
  


Current Time: Mon Dec 23 08:41:18 CST 2024