Re: Text search

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: 16 Aug 2006 06:25:21 -0700
Message-ID: <1155734721.243738.75120@m73g2000cwd.googlegroups.com>

Ralph schreef:

> 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 ? !

What would be NLS dependent for a 9999AAAAAA format? Once more, lookup nls_sort, choose the one you want, and alter your session
to use that. Apart from that, it works - use order by to check for anomalies Received on Wed Aug 16 2006 - 08:25:21 CDT