469,282 Members | 1,749 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,282 developers. It's quick & easy.

Removing a period from a string

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
Jul 19 '05 #1
1 4312
UPDATE table SET column = REPLACE(column, '.', '')
"Bill" <bi***********@gospellight.com> wrote in message
news:8d**************************@posting.google.c om...
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

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by ChrisC | last post: by
9 posts views Thread by Ray | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.