Re: problem with like

Anurag Varma a écrit :

> I guess the deeper problem is the datatype CHAR!
> So a name like 'mat' will be stored as 'mat[17 spaces]'
> For this very reason the datatype 'VARCHAR2' exists.
>
> Try
> select * from table where rtrim(column) like '%t'
>
> ... and if you want case insensitive also then:
> rtrim(upper(column)) like '%t'
>
> Anurag

Thanks, you are right !!!!! Received on Thu Sep 20 2001 - 10:03:28 CDT