Re: Text search

From: Ralph <ralph.wiechmannremovethis_at_t-online.de>
Date: Tue, 15 Aug 2006 20:04:20 +0200
Message-ID: <ebt2br$nev$00$1@news.t-online.com>

Frank van Bortel wrote:

> Ralph schreef:
>

>> Hi *
>>
>> following situation
>>
>> a table with a column ID varchar2(4000)
>>
>> I want to search with an ID-Range like
>>
>> select * from table where id between '12' and '1234AABBG'
>>
>> Does this work and what about NLS- dependent information ?
>>

>
> No - what whould be "in between" ?!?
>
> Look up NLS_SORT in the manual at tahiti.oracle.com
>

Assume id has value of 12NNXXXXX where NN are numbers and XX are chars. the between should define a range of all Id's "between" 12 amd 1234AABBGG. Maybe regular expressions can make it ? ! Received on Tue Aug 15 2006 - 13:04:20 CDT