Newbie: Search ignoring whitespaces
Posted by:
Toxic Head
Date: February 21, 2007 04:42AM
Hi all,
I've (possibly a simple) question.
I've a database table with a StringColumn.
There are values in like:
[1] '1 2 A 7'
[2] '12 A 7'
[3] '1 A 2 7'
[4] '1 2 3 A 7'
How can I query (performant) f.e. for the search string '12 47' and receive the example rows ([1],[2]) above, in the result??
In other words the order of the characters should be respected and also no other Char has to be in the Sequence, only the whitespace should be ignored.
ThanX in Advance!
ToxiC
Subject
Views
Written By
Posted
Newbie: Search ignoring whitespaces
3389
February 21, 2007 04:42AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.