Removing a period from a string

[Bill]

I need to remove a period from a string of data. I have a whole column
of numbers that have a period distributed randomly in them, and I need
a way to pull the period out. Unfortunatly, the period is not at a
fixed interval from the start or from the end. Sometimes it's like
this:
08307.33214

and sometimes it's like this:
66543354.2213

At any rate, I have a whole column of these in SQL Server 7.0 and need
to use the number as is for some issues, but without the period for
others.

Can someone please show me how to write a function that will remove
the period no matter where it is located in the string?

Thanks!

Bill

 

[Aaron Bertrand - MVP]

UPDATE table SET column = REPLACE(column, '.', '')