manejo de string

Trata:

use northwind
go

declare @s varchar(128)
declare @a varchar(25)
declare @b varchar(25)
declare @c varchar(25)
declare @d varchar(25)

set @s = 'string1:string2:string3:string4'

select
@a = parsename(replace(@s, ':', '.'), 4),
@b = parsename(replace(@s, ':', '.'), 3),
@c = parsename(replace(@s, ':', '.'), 2),
@d = parsename(replace(@s, ':', '.'), 1)

select
@a as [@a],
@b as [@b],
@c as [@c],
@d as [@d]
go


AMB


"Mauro" wrote:

como pudo separar lo siguiente:

'string1:string2:string3:string4'
en :
@a='string1'
@b='string2'
@c='string3'
@d='string4'