When i use an ODBC query (Shown below) in excel it will return exact matches

SELECT  "SURNAME","FORENAME"
FROM DATABASEname
WHERE ("SURNAME"='PARKINSON' and "FORENAME"='CRAIG')

If the forename is Craig Bruce it will not show any results.

My initial thouights were:

SELECT  "SURNAME","FORENAME"
FROM DATABASE
WHERE CONTAINS("SURNAME"='PARKINSON' and "FORENAME"='CRAIG')

Also tried

SELECT  "SURNAME","FORENAME"
FROM DATABASE
WHERE ("SURNAME"='PARKINSON') and ("FORENAME" like %CRAIG%) 

but no matter how i alter the query the “contains” for the Forename does not bring any results just lots of Datasource errors