Replacing space in particular section of the field with Update query

[google]

Hi Guys, I am trying to remove the space between $ and value. I have used the below mentioned query with * as a wildcard but it changes the whole value of cell into $*, I know i should use something like REGEX but i am not sure how to apply it. Please advice on how to solve this.

UPDATE TABLE NAME SET TABLE NAME.[COLUMN NAME] = "$*"
WHERE (((TABLE NAME.[COLUMN NAME]) Like "$ *"));

Example data of what i am trying to replace with.

Existing format	Required format
$ 58,700,000	$58,700,000
$ 2,076,890,000	$2,076,890,000
$ 313,797,052	$313,797,052

[recyan]

Not sure, just check out if below is of any help :

UPDATE Table1 SET Table1.ExistingFormat = Replace([ExistingFormat],"$ ","$");

Note :
1) PLEASE BE CAREFUL.
2) Was wondering why $ needs to be stored in the field value.

Thanks

[google]

Hurray!!! It worked, Thank you recyan.

[google]

Hurray!!! It worked, Thank you Recyan.

[recyan]

Glad you found it helpful.

Thanks

[google]

+1 for you

[recyan]

Thanks google