Quote: Originally Posted by
whitecrook i haven't done it directly in SQL before, I'd use php or something but a regex might be something like this: remove all punctuation etc to leave just letters and numbers. s/[^a-zA-Z0-9]+//g (find everything not alphanumeric one or more times and replace with 'nothing') extract a...