Hi Is there an easy way to write a select using like that ignores any whitespace.
Basically I need to match telephone numbers that may or may not have been initially input with spaces included.
select * from customers where telephone like "123456"
would match fields where telephone = "123 456" or "123456" or " 123456" or "12 34 56"
Am I going to have to clean my data and force all user input ino this clean format or is there a select I can use on the data I have?