find and replace syntax

[trevorb]

Is there a way (using a combination of "stuff" and patindex&#34
to do the following:

replace this --> 1 2 3 4 5
with this --> 12345
or better yet --> 1,2,3,4,5

note: these "spaces" are tab delimited!

any help would be appreciated!
TB

[Ananth]

use the REPLACE function. REPLACE(sourcestring, searchfor, replacewith)

select REPLACE('1 2 3 4 5',' ', ',&#39 will return 1,2,3,4,5


------------
trevorb at 5/10/01 7:46:01 PM

Is there a way (using a combination of "stuff" and patindex&#34
to do the following:

replace this --> 1 2 3 4 5
with this --> 12345
or better yet --> 1,2,3,4,5

note: these "spaces" are tab delimited!

any help would be appreciated!
TB