Hi everyone,<BR><BR>I&#039;m trying to use the Full-Text SQL ability to search my table for whatever words the user types in to search for, but I&#039;m running into trouble getting this statement to work.<BR><BR>Here&#039;s what I have so far:<BR>SELECT FT_TBL.Title, FT_TBL.Description, FT_TBL.Resolution, KEY_TBL.RANK <BR>FROM tblArticles <BR>AS FT_TBL INNER JOIN <BR>CONTAINSTABLE (tblArticles, *, &#039;" & searhcriteria & "&#039;) <BR>AS KEY_TBL ON <BR>FT_TBL.ArticleID = KEY_TBL.[KEY] WHERE KEY_TBL.RANK &#062; 2 ORDER BY KEY_TBL.RANK DESC<BR><BR>Now the search criteria I went in and replaced any spaces in there with "* *" to put wildcards around the individual words.<BR><BR>Anyone know of the best way to use CONTAINS TABLE to this kind of thing?<BR><BR>Thanks!<BR><BR>Z