We have a very big sql database with over 600,000 products from about 2000 manufacturers. All manufacturers have different part numbers for the items.<BR><BR>The customers are checking price with either our part numbers or the manufacturer part numbers. Some manufacturer part numbers have (-), (), (.) etc (example 234-567 or 23-4567 or 23 4567 etc) In most of the cases when customers enter these part numbers they either forget to put the (-), (), (.) or they enter at the wrong places.<BR><BR>I need a suggestion as to how we can ignore these (-), (), (.) while sending a query to the SQL database so that no matter where they put these (-), (), or (.) they should get the right part number.<BR><BR>Thanks.