>The field is actually C(30) and contains the description:
>
>Del Monte Green Beans No Salt
>
>"No Salt" just happens to stretch to the second line.

There is another option that is more flexible, but a little more work.

In your select statement, you can bust out the description field into to 2 description fields.

However, it is not as easy as:

select (substr(description,1,15)) as descrip1, (substr(description,16,15)) as descrip2, ...

because that may bust the field right in the middle of a word. You would have to make the expression break the string at the last occurance of a space before the 15th place, for example. Wouldn't be that hard to do.

Of course another description would be to have 2 15 character description fields in the table...

Anyway, I hope one of these ideas works for you...