Split 60 character string every third character with pipes

SQLServerCentral » Latest topics

Split 60 character string every third character with pipes

Hi All,

I'm needing to split a 60 character string every third character with spaces/pipes and filter out any set that is '000'. For example, this:

'158001006000000000000000000000000000000000000000000000000000'

would become this

more info...