Hi Casey, I think you need to adjust your quotes. Something like this: FREETEXTTABLE(listings, *, 'FormsOf(INFLECTIONAL, ' + @search + ')' ) In other words you need to splice @search into the string using + I think. HTH Jason ________________________________ From: thelist-bounces at lists.evolt.org on behalf of Casey Crookston Sent: Mon 14/08/2006 23:18 To: thelist at lists.evolt.org Subject: Re: [thelist] MS SQL Using 'FormsOf(INFLECTIONAL,) in a full-text search More specific: FREETEXTTABLE(listings, *, 'FormsOf(INFLECTIONAL, @search') It always treats @search as NULL. What's wrong with my syntax here? Thanks! Casey -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt !