Re: Locate and loCaseInsensitive




if I have data:

Field1
ABC
abc

When I use Locate('Field1','abc',[]),I need case sensitive,but,it always
find 'ABC',why?

It is Borland`s problem,or MS`s problem?

BTW,even my sql server installed as "case senstive",the "Locate" also can
find "ABC".

ADO does not have a command equivalent of Locate. So when borland implemented
Locate in TadoDataset it used ADO's Filter capability. ADO filters are not case
sensitive.



--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.