Yeh I know - actually it doesn't seem to make a blind bit of difference - get the same records back
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 21 August 2002 11:51 To: CF-Talk Subject: Re: SQL indexes > SELECT dc.* > FROM DOCUMENT_SEARCH dc > WHERE CONTAINS(dc.title, ' "*cowboy*" ') contrary to normal sql, the full text functions want "*" as wild & search phrases contained in ""(double quotes). ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists