This should do it.... WHERE CONTAINS(ProductName, ' "satachi" OR "internet" ')
-----Original Message----- From: Russ 'Snake' Michaels [mailto:[EMAIL PROTECTED] Sent: 06 November 2003 16:00 To: [EMAIL PROTECTED] Subject: [ cf-dev ] SQL CONTAINS I am using the SQL contains clause. E.g Select * from table WHERE CONTAINS (column, 'value') But it doesn't seem to be able to cope with strings with more than one word. E.g WHERE CONTAINS (column, 'satachi internet') Produces the error ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error occurred near 'internet'. Expected ''''' in search condition 'satachi internet'. This seems mad that you can only do single word searches, is there anyw ay round this restriction. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.536 / Virus Database: 331 - Release Date: 03/11/2003 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
