Searching all fields in a record

Tech-Archive recommends: Fix windows errors by optimizing your registry

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
.

Relevant Pages

  • Re: Sessions and Pagination Problem
    ... I don't get an error with the query. ... I have multiple if statements that append "AND"'s to the SQL statement ... If you click on page numbers and the prev or next links, ...
    (comp.lang.php)
  • Re: Are Linq-SQL methods commutative
    ... because to translate what is being done in LINQ to ... of the previous query. ... the intention of the linq query with SQL. ... get 2 different resultsets by specifying them in a different order, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: problem with IWbemService.ExecNotificationQuery()
    ... semi-sync by specifying 'return immediately' is just as performant in nearly ... regular ExecQuery is required to get non-event informational WMI objects. ... >>> Notification or Asyn.Notification query. ... >>> an event query results in a request to poll all objects in a namespace. ...
    (microsoft.public.win32.programmer.wmi)
  • Re: Searching all fields in a record
    ... >Is there an SQL statement where I can search all fields in a record without ... >specifying the field names? ... >to time and I don't want to rewrite this query every time. ... In a properly normalized database this search should essentially NEVER ...
    (microsoft.public.access.queries)
  • Re: query wont return results
    ... Following is the SQL statement of my query ... FROM (tblCourses INNER JOIN tblHoles ON tblCourses.CourseID = ... Post the SQL statement of it. ... Prev by Date: ...
    (microsoft.public.access.queries)