Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

longest match starting digit.

weekendDec 24 2005 — edited Dec 27 2005
Hi

(9i release 2/columns (varchar2 (30))
I wish to have a query that picks the value having the longest match starting digit(s) with my input.

Example
In put ‘5544’

ColumnA
5500
554
5540
5539

The query will return ‘554’ as it got longest match starting digits with input.
Will not pick ‘5540’ as matching end at last digit ‘0’.

So can I any one play the magic for me.


Wishes
Jawad

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 24 2006
Added on Dec 24 2005
3 comments
801 views