If you have a table with one column called
Col_Name and the following four records
Foos
Foosball
Foos ball
Foos*
and you create a query based on the table with the criteria
="Foos*"
your query returns:
Foos*
But, if your criteria is
Like "Foos*"
your query returns the following four records:
Foos
Foosball
Foos ball
Foos*
The SQL statement using Like for this query is as follows:
SELECT DISTINCTROW tablename.Col_Name
FROM [tablename]
WHERE ((tablename.Col_Name Like "foos*"));
The SQL statement using = for this query is as follows:
SELECT DISTINCTROW tablename.Col_Name
FROM [tablename]
WHERE ((tablename.Col_Name="foos*"));