I'm hoping someone here can help me out with the following: I have a database of items and item numbers, something like this:
ID Item 1-12 Apples 12-123 Oranges 123-1 Bananas Here's the problem that I'm running into: I want to run a query for item numer 112, but I don't know where the dash is in the Item Number (ID). Is there any way that I can query the database for the item number and just have it ignore the dashes that may or may not be in the field name? Right now I'm using a PostgreSQL 7.3 database, but if this is possible with another database system chances are good that postgre can do the same thing in some way. I'd really appreciate any pointers! Thanks! -Jordan ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204430 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
