The standard SQL output for long/LOB columns is indeed limited to 40 characters. If you want to display your data in a specific format, you need to use the OnData event. Here you can process each individual row, and can use the AddOutput function to write the formatted output. The ooData option should be excluded from the OutputOptions property.
------------------
Marco Kalter
Allround Automations