Re: Searching all fields in a record

Tim

A couple red flags went up when I read your post.

First, a database design that puts values in any field requires searching
"all fields". This sounds very much like ... a spread***, not a
relational database!

Second, have field names that "change from time to time" doesn't sound like
the data structure has been finalized. If you provide some examples, the
newsgroup may be able to offer some suggestions.

Good luck

Jeff Boyce
<Access MVP>

"TimW" <TimW@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:61B974D4-607A-4135-91DA-0A353783F300@xxxxxxxxxxxxxxxx
> Is there an SQL statement where I can search all fields in a record
without
> specifying the field names?
>
> such as: Select * from [table] where * is like "whatever"
>
> I would like to use a simple query as the field names can change from time
> to time and I don't want to rewrite this query every time.
>
> Thanks in advance.
>
> TimW

.