Home Forums SQL Server 2016 SQL Server 2016 - Development and T-SQL Split 60 character string every third character with pipes RE: Split 60 character string every third character with pipes
Bert-701015
SSCommitted
Points: 1615
More actions
February 8, 2018 at 1:41 pm
#1979103
replace(cast(FORMAT(cast(Column1 as float), '### | ### | ### | ### | ### | ### | ### | ### | ### | ### | ### | ### | ### | ### | ### | ### | ### | ### | ### | ###') as varchar(max)),' | 000', '')