Remove commas

[Guest]

Using Office 2003 and Windows XP,

I need a SQL string (or other method) to remove a comma from a column in a
table; few thousand rows.

The fields are variable length strings, e.g.:

df00253,50053
agfa1b,1
rl445k,55022299ffr

Can someone please post a generic SQL example that could do this?

Thanks much in advance.

 

[Marshall Barton]

Using Office 2003 and Windows XP,

I need a SQL string (or other method) to remove a comma from a column in a
table; few thousand rows.

The fields are variable length strings, e.g.:

df00253,50053
agfa1b,1
rl445k,55022299ffr

Can someone please post a generic SQL example that could do this?

Access provides the Replace function that should do that in
Jet SQL:

Update table Set field=Replace(field, ",", "")