> OK, the DATABASE field should not be nested inside a { MERGEFIELD }
> field.
> At the moment, Word is treating the result of the Database field as the
> name
> of a column in your merge. You can select the { DATABASE } field and
> cut/paste it so it is outside the MERGEFIELD field.
>
> Peter Jamieson
>
> "klav" klav.1o7aoa@news.wordbanter.com wrote in message
> news:klav.1o7aoa@news.wordbanter.com...-
>
> I'm using Word 2003. My data source is an Oracle database.  My SQL
> statement looks like this:
>
> {MERGEFIELD {DATABASE  \d "c:\\mydatasource.odc" \c "connection
> string"
>
> \s "SELECT \"TITLE\" FROM \"TABLE_NAME\" WHERE ((\"ID\" =
> '12345'))"}\*Upper}
>
> Peter Jamieson Wrote:-
> 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
>
> "klav" klav.1o4209@news.wordbanter.com wrote in message
> news:klav.1o4209@news.wordbanter.com...-
>
> 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?
>
> --
> klav--
>
> --
> klav-