Re: problem with like

Cameron Abbott a écrit :

> Where in the name is 'ot'? %ot will only return names that end in 'ot'.
> It is also case sensitive. Try
> select * from my_table where upper(my_name) like '%OT%'
>

The case is correct ...

>
> >
> > In my_table, I have a column my_name type char(20)
> > when I do:
> >
> > select * from my_table where my_name like '%t'
> >
> > nothing is returned...
> > though there are records like %t
> >

Is it a problem with char(20) ?
select * from my_table where my_name like '%t%' return the good results Received on Thu Sep 20 2001 - 09:42:02 CDT