C
CL
I want to query a number of database fields to return only those
records that contain a specific string, and I want the match to be
case-sensitive.
I am currently using 'LIKE' in a query that looks something like this:
SELECT *
FROM tblArtistInfo
WHERE tblArtistInfo.ArtistName LIKE '%Joe Blow%'
This query returns results when it encounters 'Joe Blow' or 'Joe blow'.
How do I make sure my results are case sensitive and only return
matches for 'Joe Blow' and NOT 'joe blow', 'Joe blow', or 'joe Blow'?
records that contain a specific string, and I want the match to be
case-sensitive.
I am currently using 'LIKE' in a query that looks something like this:
SELECT *
FROM tblArtistInfo
WHERE tblArtistInfo.ArtistName LIKE '%Joe Blow%'
This query returns results when it encounters 'Joe Blow' or 'Joe blow'.
How do I make sure my results are case sensitive and only return
matches for 'Joe Blow' and NOT 'joe blow', 'Joe blow', or 'joe Blow'?