Posted by Dave Fountain on 03/04/07 09:36

On Thu, 01 Mar 2007 18:32:16 GMT, "David Smithz"
<dave1900@blueyonder.co.uk> wrote:

>Ideally another way of doing this would be to use the regular expression in
>a replace statement (currenlty playing around with this).
>
>e.g.
>
>SELECT REPLACE (mobile_number, ' ', '') FROM `mytable` WHERE 1 LIMIT 5
>
>the above works in removing the blank spaces, but if I could instead have a
>regular expression to say, instead of just spaces, any non numercial
>character, this would be good.
>
I know nothing about the topic but is there a function that allows you
to *keep* numerical characters, then you would only have to check for
10 cases?

[Back to original message]