in reality, you should change the data type used in the database rather than the SQL.
Especialy when it comes to the delete statement, you would not want to use an sql state like this:
DELETE FROM table WHERE column LIKE value
this could potentially delete an unintended record.