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%'
"thierry" <thierry.constant2_at_wanadoo.fr> wrote in message
news:3BA9F3E3.56E85B92_at_wanadoo.fr...
> Hi,
>
> 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
>
> What's happen ???
> Thanks
>
>
>
Received on Thu Sep 20 2001 - 09:07:58 CDT
