I was faced with a field in the database that had a comma separated list of INT’s with a space after the comma. The application searched this field to generate the recordset to display on a web page. First I tried using LIKE, with something along this line: ($state_id is being passed by PHP) SELECT […]