> What's wrong with using the wildcards that are built into most SQL > variants? > > SELECT * FROM table WHERE item_id LIKE '%#abcdef' > > Will select all records where the item_id field ends in '#abcdef'
That works if you know the user is always going to enter the last 7 characters of the product id, but that's not how the OP characterized the problem. The OP talked about search strings where multiple characters had been omitted from different parts of the product id. Ben -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php