Replace Example

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Different

Q&A for power users of Apple hardware and software

DECLARE	@TempTable AS TABLE(ID INT, DescriptionText VARCHAR(50))
INSERT INTO @TempTable
SELECT		1, 'Replace my name - Jimmy'

INSERT INTO @TempTable
SELECT		2, 'Replace my name - Jimmy'

INSERT INTO @TempTable
SELECT		3, 'Replace my name - Jimmy'

INSERT INTO @TempTable
SELECT		4, 'Replace my name - Jimmy'

INSERT INTO @TempTable
SELECT		5, 'Replace my name - Jimmy'

SELECT	*
FROM	@TempTable

UPDATE	@TempTable
SET		DescriptionText = REPLACE(DescriptionText, 'Jimmy', 'Dallas')

SELECT	*
FROM	@TempTable

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results