Like operator not working with MS Access (1 Viewer)

T

tarig

Guest

• Mar 14, 2005

• #1

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'));

 

R

Rich

Guest

• Mar 14, 2005

• #2

Like("*Norm") Like("*Norm*") Like("Norm*") ???

 

Mile-O

Back once again...

Local time

Today, 10:30

Joined

Dec 10, 2002

Messages

11,316

• Mar 14, 2005

• #3

tarig said:

WHERE (((Unterlagen.Titel) Like 'norm'));

Click to expand...

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