View Full Version : Like operator not working with MS Access


tarig
03-14-2005, 06:41 AM
I use this query to search for data, but i get no result .. just an empty one .. although i have many records in the database, which fullfiled the criteria..
Is there any other way to search for data..


SELECT Unterlagen.lfdNr, Unterlagen.Titel, Unterlagen.Art
FROM Unterlagen
WHERE (((Unterlagen.Titel) Like 'norm'));

Rich
03-14-2005, 06:45 AM
Like("*Norm") Like("*Norm*") Like("Norm*") ???

Mile-O
03-14-2005, 06:47 AM
WHERE (((Unterlagen.Titel) Like 'norm'));

As you don't specify a wildcard, as Rich has pointed out, you are currently only looking for an exact match.