Access <-> MyODBC <-> MySQL problem

[Struan Bartlett]

Hi. I've an Access 97 database with MySQL (3.22.16a-gamma-log) tables
linked via MyODBC 2.50.22.

I've designed an Access Query such that the Access 'SQL View' says:

SELECT RawM.Name, * FROM RawM WHERE (((RawM.Name) Like 'MYINFOBOX%'));

However, the appropriate excerpt from the MyODBC log file says:

MSACCESS        de:aa	ENTER SQLExecDirect 
		HSTMT               0x008b24f0
		UCHAR *             0x086513d4 [      -3] "SELECT RawM.ID FROM RawM WHERE (Name =
'MYINFOBOX%' ) "
		SDWORD                    -3

MSACCESS        de:aa	EXIT  SQLExecDirect  with return code 0 (SQL_SUCCESS)
		HSTMT               0x008b24f0
		UCHAR *             0x086513d4 [      -3] "SELECT RawM.ID FROM RawM WHERE (Name =
'MYINFOBOX%' ) "
		SDWORD                    -3

MSACCESS        de:aa	ENTER SQLFetch 
		HSTMT               0x008b24f0

MSACCESS        de:aa	EXIT  SQLFetch  with return code 100 (SQL_NO_DATA_FOUND)
		HSTMT               0x008b24f0

And here's the appropriate except from the MySQL log:

990318 11:01:52    2126 Connect    struanb@stripped on newsnow
                   2126 Query      SELECT Config, nValue FROM MSysConf
                   2126 Query      SELECT RawM.ID FROM RawM WHERE (Name = 'MYINFOBOX%' ) 
990318 11:02:35    2126 Query      SELECT RawM.ID FROM RawM WHERE (Name = 'MYINFOBOX%' )

Umm?! Can anyone tell me how/why the SQL "Like" (in the original SQL
statement) been changed to an "="? And by what? Or should I post this
query to the MyODBC list? 

Thanks in advance.

Kind regards,

Struan Bartlett.

------------------------------------------------------------------
Struan Bartlett         | The Premier UK News Aggregation Web site
Managing Director       | http://www.newsnow.co.uk/
NewsNow Publishing Ltd  | Your remote control for news on the Net
                        |
Tel.  : [phone]   | "The only straight lines found
Mobile: [phone]     |  in nature are those drawn by us"
------------------------------------------------------------------