replacing characters in a field 1

[link9]

Hello all --

I have a field in my database, which holds varchar data in it in the format:

2001-001

several thousand rows, and I need a command that will go through and replace all the -'s with .'s such as

2001.001

so that I can then convert the data type to float...

what is my syntax?

the column name is projectNum, btw.

thx
Paul Prewett

 

[foxdev]

replace(ProjectNum, '-', '.') Robert Bradley

http://www.lowcostprints.com

http://www.foxdev.com

 

[link9]

Actually, I was hoping for a SQL statement that would do it... if there is one.

thx
paul

 

[tlbroadbent]

Update MyTbl Set MyCol=replace(MyCol,'-','.') Terry

http://members.home.net/tlbroadbent/index.htm

 

[link9]

oic -- thx