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 #372718] Mon, 05 March 2001 01:58
ramu
Messages: 82
Registered: February 2001
Member
Hi,

Try this one...

SELECT column_name1 FROM table_name WHERE SUBSTR(column_name1,length(column_name),1) NOT IN('0','1','2','3','4','5','6','7','8','9') ORDER BY column_name1;

This is for ending column_name by alphabetics only.

If you want to select ending with numbers then apply the same query by eliminating NOT..

Thanks..

Ramu..

Report message to a moderator

Previous Topic: sure this will work as per babu's view.
Next Topic: Regarding Check constraint in Date field
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 13:31:37 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.