Forum Moderators: buckworks
The search that comes with most shopping carts is simply too stupid, usually with no margin of error. A simple typo on the customers side and he might not find a certain product although you are selling it.
Full-text search is much better, as it'll account for plurals ("Widgets") or different phrasing ("Small Blue Widget"), and order results according to match strength. Plus, if you use SQL Server Express, it's free.