[V4RB2] Different results for search between Valentina and MySQL

[Kem Tekinay]

I am able to run a search that yields different results in Valentina and
MySQL, and I don't know which one is doing it correctly (although I think
it's MySQL).

If I have the zip codes 10597 and 10579, MySQL will find both if I use fld
LIKE '105%9%' and Valentina will find only 10579 if I use fld.FindLike(
"105%9%" ).

Is this a bug in Valentina, MySQL, or just different implementations of SQL?

__________________________________________________________________________
Kem Tekinay                                                 (212) 201-1465
MacTechnologies Consulting                              Fax (914) 242-7294
545 Eighth Avenue, Suite 401                          Pager (917) 491-5546
New York, New York 10018                    http://www.mactechnologies.com

To join the MacTechnologies Consulting mailing list, send an e-mail to:
  mactechnologies_consulting-subscribe at yahoogroups.com