Not Numeric Query

[delaap]

Hi,
I have a table with telephone numbers within it. I'm trying to construct a query that will return all the recs that are not numeric i.e.

+44 01206 851851
(01206) 851851
01206-851851 etc...

The problem occurs with the spaces as these are seen as non numeric.
Does anyone have any ideas on how to construct this query succesfully.
Thanks

 

[JamesLean]

SELECT phone
FROM table
WHERE ISNUMERIC(REPLACE(phone, ' ', '')) = 1

--James