E
Evangelos Daflos
there is a field that contains numbers using . for decimal so i need to
create a field that replace . (dot) to , (comma)
the numbers are like 3 not 3.00 or 3.1 not 3,1 or 3.01 not 3,01 so if there
are number without decimal does not present .
in this case i am using the follow query
UPDATE table SET table.field1 = Replace([field1],".",","), table.field2=
Replace([field2],".",",");
but i need to build a command without run that query
create a field that replace . (dot) to , (comma)
the numbers are like 3 not 3.00 or 3.1 not 3,1 or 3.01 not 3,01 so if there
are number without decimal does not present .
in this case i am using the follow query
UPDATE table SET table.field1 = Replace([field1],".",","), table.field2=
Replace([field2],".",",");
but i need to build a command without run that query