have you tried removing the quotes enclosing 5? ----- Original Message ----- From: Bernd VanSkiver To: SQL Sent: Tuesday, February 12, 2002 9:56 PM Subject: FREETEXT with numbers
I am using Microsoft SQL 2000 and have a full text index set up on a table that I am trying to use the FREETEXT command with. Whenever my search contains a numeric value it bombs, for example: SELECT ID FROM Product WHERE FREETEXT(ProductName, '5') I get this error with that query: Search on full-text catalog 'Product' for database ID 207, table ID 402100473 with search condition '5' failed with unknown result (80041605). If I have just text it works fine, or a number and test like '5test' that works, but '5 test' would crash too. There has got to be a way to do this, I just don't know the syntax for it. Bernd VanSkiver [EMAIL PROTECTED] ColdFusion Developer ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
