Re: Text search

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 15 Aug 2006 19:49:03 +0200
Message-ID: <ebt15t$97g$2@news6.zwoll1.ov.home.nl>

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

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Tue Aug 15 2006 - 12:49:03 CDT