I have a commerce server database that uses a full text index to search
product numbers and descriptions.  My issue is that some of my product
numbers contain single characters, "EMT 1" for example, and the Contains
clause does not seem to treat this phrase as an exact match search when I do
something like

select *
from <table>
where contains(*, '"EMT 1"')

It finds that product and a number of other products that happen to contain
EMT in the description.  Is there any way that I can get the index to
recognize the entire string?  It seems that it treats the "1" as a noise word
and just drops it from the criteria.  

I have tried stripping out all puncuation and white space from the product
number and adding that value to the FT Index but it complicates any Keword
searches that may have valid white space in that I can not universally strip
white space out of the criteria that the user entered to try to get a match.

Chris