You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by Hans Novak <hn...@repcom.de> on 2007/11/23 14:12:07 UTC
search without some special characters
Hi Ng,
i have in my db round about 5000 phone numbers in the manner
[prefix]-[number]
[prefix] [number]
[prefix]/[number]
and maybe some other cases.
i have a telecom system, who gives me the numer like
[prefix][number] (without any other characters)
how can i search in my db to find the right record ?
one solution can be to make a second field without any characters except
0-9 and then serach this second field, but this is not perfect.
Hans
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org