String manipulation

[rtdvoip]

hiya fellas,

any suggestions on how I may take out some '-' from a phone number using a string function in sql?

for example

phone_number is '777-777-777'
i need it as 777777777

on my version it tells me that ltrim and rtrim only takes one argument.

thanks in advance

 

[rtdvoip]

I am in the process of placing the online books back.
They were taken off by the last programmer.

thanks

 

[zhavic]

Take to look at this thread thread183-571441

Zhavic

---------------------------------------------------------------
In the 1960s you needed the power of two Comodore64s to get a rocket to the moon. Now you need a machine which is a vast number of times more powerful just to run the most popular GUI.