Re: parameter

From: Chris2 (rainofsteel.NOTVALID_at_GETRIDOF.luminousrain.com)
Date: 01/29/05


Date: Sat, 29 Jan 2005 05:33:36 -0800


"al9315" <al9315@discussions.microsoft.com> wrote in message
news:8398F03F-B83F-4F73-A36B-E86AAEE53B0A@microsoft.com...
> Typed question earlier - cannot find it on here ???????
> Query - Record Collection - e.g. "We wish you a Merry Xmas" -
Parameter
> Query - type in e.g. Merry Xmas - search ALL track fields (in my
case - 24
> fields) in ALL records for any instance of tracks with "Merry Xmas"
in ?

If I understand correctly:

SELECT T1.Track
  FROM YourTable AS T1
 WHERE T1.Track LIKE "*Merry Xmas*";

Sincerely,

Chris O.