470,811 Members | 1,161 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,811 developers. It's quick & easy.

Multiple Search Criteria using FREETEXTTABLE function

8
Hi,

How would one allow for possible multiple search criteria using FREETEXTTABLE. For example, my table "listings" has a full-text search catalog, and I may want to:

SELECT * FROM listings WHERE name LIKE @name AND city LIKE @city

I've got it working to select only by name:

SELECT listing_id, RANK, name, address, city, zip, heading, phone
FROM listings a,
FREETEXTTABLE(listings, name, 'FormsOf(INFLECTIONAL, taxes accounting') b
WHERE [KEY] = a.listing_id
ORDER BY RANK DESC, name

How would I modify this query to also search for @city from the city column?

Thanks!

Casey
Aug 14 '06 #1
1 7911
iam_clint
1,208 Expert 1GB
http://msdn2.microsoft.com/en-us/library/ms177652.aspx

hope this link helps you.
Aug 14 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by TH | last post: by
2 posts views Thread by Scott Cannon | last post: by
reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.