Remove commas

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
XP said:
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?
Click to expand...


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

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