Search news group, or
use
select... from ... where upper(name) like 'ST%'
That will force a full table scan. Ifyou want to use an index and you have
8.1.7 then create a function based index.
Jim
"Stefan Wilke" <Stefan_Wilke_at_mgb.man.de> wrote in message
news:3bc4452e.193216049_at_news...
> Hello,
>
> I have a problem with the like operator in a select statement.
>
> In a table there is i.e. the namefield
>
> Name
> ---------
> Stefan
> Otto
> Hugo
> ...
> ...
>
> If I try to select data with the folowing Statement:
>
> select name from <table> where name like 'St%'
>
> Stefan is selectet.
>
> but if I try :
>
> slelect name from <table> where name like 'ST%'
> nothing is selectet
>
> How do I force the like statement to work not case sensitive?
>
> Thanks
>
> Stefan
Received on Thu Oct 11 2001 - 20:13:11 CDT
