Microsoft Interview Question

How would you search a database for a matching string ignoring certain punctuation/special characters? What pre-processing would you do?