Text search

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 ?

Thanx for your help

Ralph Received on Tue Aug 15 2006 - 11:59:56 CDT