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

Remote server delete

Hi,
Can any please shed some light on the following problem or direct me to an
information source ?
DELETE remoteserver.database.schema.table
returns the following error message.
iServer: Msg 7345, Level 16, State 1, Line 2
OLE DB provider 'MSDASQL' could not delete from table '"S1031118"."CISDTA6".
"DXDV36001"'. There was a recoverable, provider-specific error, such as an
RPC failure.
ODBC: Msg 0, Level 19, State 1
SqlDumpExceptionHandler: Process 106 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
[OLE/DB provider returned message: Multiple-step operation generated errors.
Check each status value.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowsetChange::DeleteRows
returned 0x80040e21: DBROWSTATUS_E_FAIL].
Any help would really be appreciated.
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Forum...amming/200511/1What kind of Linked server is this ? (product etc.)
Jens Suessmeyer.|||Sorry about the delay.
The linked server is configured as server type: other data source
provider name:
Microsoft OLE DB provider for ODBC drivers
Jens wrote:
>What kind of Linked server is this ? (product etc.)
>Jens Suessmeyer.
Message posted via http://www.webservertalk.com