Replace Command?

[Seabz420]

I have a nvarchar field (COLDES) in the db COL. I need to replace any comma in the field with a space (there are about 10,000 records to go through). I've created a Stored Procedure that looks like this:

CREATE PROCEDURE [dbo].[LoanAnalysis_Update] AS
BEGIN
UPDATE COL
SET COLDES = REPLACE([COLDES],","," ")
END
GO

I'm I reaching in the right direction?

 

[Joeybear23]

What is teh table name you are trying to update?

SQL/SAP DBA

 

[Joeybear23]

Here is the text from BOL:

REPLACE
Replaces all occurrences of the second given string expression in the first string expression with a third expression.

Syntax
REPLACE ( 'string_expression1' , 'string_expression2' , 'string_expression3' )

Arguments
'string_expression1'

Is the string expression to be searched. string_expression1 can be of character or binary data.

'string_expression2'

Is the string expression to try to find. string_expression2 can be of character or binary data.

'string_expression3'

Is the replacement string expression string_expression3 can be of character or binary data.

Return Types
Returns character data if string_expression (1, 2, or 3) is one of the supported character data types. Returns binary data if string_expression (1, 2, or 3) is one of the supported binary data types.

Examples
This example replaces the string cde in abcdefghi with xxx.

SELECT REPLACE('abcdefghicde','cde','xxx')
GO



SQL/SAP DBA

 

[jbenson001]

REPLACE ( COLDES , ',' ,'')

 

[Joeybear23]

Would it not be:

REPLACE (COLDES, ',',' ')

SQL/SAP DBA

 

[Seabz420]

This worked!

UPDATE COL
SET COLDES = REPLACE((COLDES),',',' ')

Thanks everyone!