Setting field widths in an export

[thebign]

I have a query that I manually export as a dbf file (i.e. right-click and export). I manually export because I export to a unique directory each time. However, fields in the query that are of type string always get exported with a length of 255. Is there anyway in SQL that I can set the width a query's text field to a specific value (so that when I export it it isn't 255 characters long)?

 

[Liv Manto]

Try exporting it to a ready made empty table where the field is set to field type "memo" or whatever your software use for text data that has more than 255 chars.