I have a table set up with full-text searching, the problem I'm having is when I try to search a string with a minus sign like "A-Z of flowers." If I search for A-Z I come up with an empty set, how do I set it so the "-" is treated as part of the string?
SELECT * FROM Inventory.Inventory WHERE CONTAINS(Description, 'A-Z')
Thanks
Perrin
SELECT * FROM Inventory.Inventory WHERE CONTAINS(Description, 'A-Z')
Thanks
Perrin