We have a column field that contains more than 1000 characters. The vendor asked us to export the data as text file, pipe delimeted. However, they mentioned that if the field is more than 500 characters, it should be separated to another column in the text file. Let's just imagine the string below is 1500 characters long and is found in the column from the table. abcdefghijklmnopqrstuvwxyz They said that they want it separated. That means, each exported text file can have different number of columns. It would look like this in text file after it was been exported abcdefghij | klmnopqrs | tuvwxyz The above is just an example. Each string were cut down to 500 characters but 2 new columns on the text file were added. Can we do that using in a SELECT statement? Oh, I export using Tools->Options->Results tab->then Results to file. I just choose the pipe delimiter.