Q&A about the site for writers/artists using science, geography and culture to construct imaginary worlds and settings
declare @S varchar(1000) set @S = 'AUTH_USER|PISA\Paul|CheckName||CheckBArea||AUTH_ROLE|Anon|Name|paul|userEmail|paul@xx.com|Justification|just felt like clicking this page|HitURL|' while len(@S) > 0 begin print left(@S, charindex('|', @S+'|')-1) set @S = stuff(@S, 1, charindex('|', @S+'|'), '') print left(@S, charindex('|', @S+'|')-1) + '_' set @S = stuff(@S, 1, charindex('|', @S+'|'), '') -- print left(@S, charindex('|', @S+'|')-1) + '_' -- print @s end