Remove Comma from rows in table

Hello,
My schema is as follows:
Create table Test (Emailaddress varchar(50))
I have numerous rows that have a comma after the emailaddress and I need to
remove the comma. Example
jonsamules@.aol.com,
Any help would be great.Look up the REPLACE function in the Books Online.
Lontae Jones wrote:
> Hello,
> My schema is as follows:
> Create table Test (Emailaddress varchar(50))
> I have numerous rows that have a comma after the emailaddress and I need t
o
> remove the comma. Example
> jonsamules@.aol.com,
> Any help would be great.|||"Lontae Jones" <LontaeJones@.discussions.microsoft.com> wrote in message
news:ABB60657-A5B5-4CB6-9FDE-3CCF2C4BCA47@.microsoft.com...
> Hello,
> My schema is as follows:
> Create table Test (Emailaddress varchar(50))
> I have numerous rows that have a comma after the emailaddress and I need
> to
> remove the comma. Example
> jonsamules@.aol.com,
> Any help would be great.
Try the REPLACE function.
UPDATE Test
SET Emailaddress = REPLACE(Emailaddress, ',' ,'')
Rick Sawtell
MCT, MCSD, MCDBA

Remove Comma from an integer value

I am using crystal report 8.
I have a data base field called batch_number of type integer.
I am grouping it by batch_number.
In the report group footer i am using the Format Field and setting the
format to (1123) for the batch_number.
When the report is executed ,on the left hand side we get a Group Option which shows value that are in a group.
My problem is that the batch_number always comes with a comma
for example 10,001.In the report i am able to eliminate the comma
by using format filed dialog.
Does any one has idea on how to remove comma ?

Thanks and RegardsIs the problem with the group value? if so this also you can go to format field and make the same to eliminate the comma.|||yes this value i am using to group it.I am able to remove comma in the report footer by format field.
how can i remove comma in the top left area where the group value gets
populated when the report is executed.
How can i use format field for that value?|||i also have the same problem?help me help me

examlpe my code:

"LMB/"&ToText(truncate(tonumber({dsKertasLMB_B.BilMesyuarat}),0),0)&"/"& totext((year({dsKertasLMB_B.Tahun})),0)&"(B)"

the result:
LMB/101/2,007(B)

i need to remove the saparete thousand so that the result like this:LMB/101/2007(B)

tq