>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...
Steve Gibson