Replace (,) for (.)

[Gti]

Hi.
I want to replace the virgules(,) in all fields for dots(.)

1- O meu nome é, Nuno
2- agora, depois,
3- antes, agora,

Code:
Create Table Virgulas
(
Virg varchar(100)
)

Insert into Virgulas Values ('antes, agora,')

 

[tlbroadbent]

Use the REPLACE function in Access 2000.

REPLACE("antes, agora,", ",",".&quot

If you have Access 97 look at these links for solutions. Or do a search of the forums for references to Replace AND 97.

http://www.mvps.org/access/strings/str0004.htm

http://p2p.wrox.com/archive/access/2001-04/8.asp

http://www.aldex.co.uk/codesamp.html

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.