Thank you very much.  Substring function worked great.  I could create new columns, split data based on the length and input into new columns.

Again, I appreciate your time and comments. ...

I apologize for not indicating details.

I like to divide Column1 (varchar(250),null) into 5 columns, making Column2, Columns3, Column4, Column5, Column6, making all varchar(50),null.  We import Fixed-lengh text file into this table.  Somehow,...