Split string into columns/fields after ever 75 characters

[outofservice]

I have a table, one column that contains a long text string (varchar(500)). I would like to split the strings between empty columns/fields Ive created after, say, every 70 characters.

Any ideas?


Lauryn Bradley
SQL Server DBA

 

[swampBoogie]

I shouldn't do that in SQL. It's much easier to do in ASP/VB.