FULLTEXT search - another question

2001-09-04 Thread Marty McCoy
Hi, Thanks to all who responded to my previous question on how to get the FULLTEXT search to consider hyphens as part of a word. Now my question is, Is there a way to allow other special characters to be part of a 'word'? For example, we have the word +x-axis as part of a short description

FULLTEXT search with hyphens in data

2001-08-22 Thread Marty McCoy
Hi, I'm performing a FULLTEXT search against varchar columns of one of our tables. One of our columns contains embedded serial numbers such as 02-123456 and 04-234567. The problem that when I do a FULLTEXT search against 02-123456, it brings back results with the following values: ...