field truncated

[klav]

I am using the "insert database" command with an SQL statement to grab a
specific row of data. From that one row, I am inserting one specific
field, consisting only of text, into my Word document. I have also
incorporated the "mergeformat" switch to have the text I am pulling
appear in all caps. My problem is that the data is being truncated
after 40 characters and looks like this:

<<THIS IS AN EXAMPLE OF MY RECORD TO BE IN>>

Any ideas on why this is happening? Also, I don't want the brackets
around my data result -- how do I get rid of them?

 

[Peter Jamieson]

Which version of Word? What is the data source? Can you post the SQL here?

I have also
incorporated the "mergeformat" switch to have the text I am pulling
appear in all caps.

You could probably use the \*Upper switch instead, or there may be a
suitable function in the dialect of SQL you are using.

Peter Jamieson