SQL Like

[Matthew]

If I understand this correctly, this query will show all records where the
other field contains the word "customer".

SELECT catalog.*, catalog.other
FROM [catalog]
WHERE (((catalog.other) Like "%customer%"));

For some reason, it does not work.

Any ideas?

Matthew

 

[Kevin3NF]

The wildcard character for Access is * not %. % is SQl Server (and maybe
others).



--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

 

[Kevin3NF]

Forgot to include this:

WHERE (((Catalog.other) Like "*" & "customer" & "*"))

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

 

[Matthew]

That did it.

Thanks!

Matthew