Query to find value in ANY field?

[gdavi]

Is there a way to quickly write a query to find a value (or a wildcard*) in
ALL the fields within a given table?
Gary

[Michel Walsh]

Hi,

Not with JET. With MS SQL Server, if you have installed the optional Full-Text Searching, you can
use CONTAINS() in a WHERE clause (see BOL for more details), using * as first argument:

SELECT * FROM products WHERE CONTAINS(*, ' hot AND NOT spicy ');

for those records having hot but not having spicy, or

SELECT * FROM products WHERE CONTAINS(*, ' "hot and spicy" ');

for those records having literally "hot and spicy" .

It is very versatile, since you may look for season, seasoning, seasons ...

SELECT * FROM products WHERE CONTAINS( *, ' FORMSOF( INFLECTIONAL, season ) ' )

but that become hard to ask to supply that kind of syntax from a ... non seasonal user.

Hoping it may help,
Vanderghast, Access MVP

"gdavi" <gd...@yahoo.com> wrote in message news:tZC2a.1090$8Z5....@sea-read.news.verio.net...