MySQL - SQL programming

WrathOfAchilles · 26 Apr 2007 at 10:27

Good morning all.

Looking at tidying up a telephone_no field, removing any chars that are not numbers (i.e any (), spaces, letters etc) The field is varchar.

I have been looking at various string functions, just woundered if anyone had any code snippets i might find useful?

Kind regards,

Martin

marc2003 · 26 Apr 2007 at 10:35

edit: nvm, i didn't read the question properly.

WrathOfAchilles · 26 Apr 2007 at 10:38

Hmm, was hoping to use SQL rather than PHP.

Cheers tho,

Marty

marc2003 · 26 Apr 2007 at 10:39

martinweston said:
Hmm, was hoping to use SQL rather than PHP.

Cheers tho,

Marty

just edited after i realised.

GravyMonster · 26 Apr 2007 at 10:48

not really sure on MySQL as i us MSSQL, but there should be some inbuilt functions to do what you need.

Have a google for 'trim', 'mid', 'replace' and 'isnumeric'