Problem with quotations

[russellpehrson]

I have to work with access and the query that works need double quotations marks in the sql statement I have tried just about every thing but nothing works like it should here is the code. Could some please tell me what I need to do to fix it please?

$cur= odbc_exec( $conn, "select Client.[Case Number], Client.[Last Name], Client.[First Name], Client.[Court Case Number], Client.[Closed]
FROM Attorney INNER JOIN Client ON Attorney.AttorneyID = Client.AttorneyID
WHERE (((Client.[Last Name]) Like \"M\" & \"*\") AND((Attorney.PublicDefender)=Yes))
ORDER BY Client.[Last Name]");

[tbach2]

fwiw--
try assigning the select statement to a variable before the odbc_connect? If nothing else, it might separate things enough that you might see the problem.