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 ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
