I'm having a little trouble to input some data in my sql server database because the source files that are a DBF database that are formatted diferently in some numeric fileds. The fields contain values like 34,5 and 56,7. I need to replace these "," for "." so I don't mess up the insert on sql. I cannot do this with de code in VB
(my system is in VB6 by the way) because I'm building the insert statement inside the select of the DBF. something like this.
rsdbf.open " select 'insert into table1 (campo1, campo2) values('+campo1+','+campo2)"
I need something like select 'insert into table1 (campo1, campo2) values('+replace(campo1,",",".")+','+campo2)
Thanks in advance
PS: Sorry about some gramatical errors, my english is not that good.