I am calling a SQL stored procedure with an output parameter, which is declared as follows:

CREATE PROCEDURE dbo.PSP_PXGetFilterText
@pPXUserFilterSK uniqueidentifier,
@pFilterText varchar(1000) = '' OUTPUT
AS ...

VFP calls the stored procedure as follows:

lcFilterText = ''
lcSQL = "Exec PSP_PXGetFilterText '" + PXUserFilterSK +"', ?@lcFilterText"
lnRetVal = SQLExec(lnConn, lcSQL)

The stored procedure runs successfully, but lcFilterText only contains the first 255 characters of the output parameter.

Is ODBC truncating to a length of 255?
What can I do to get the full string?

Thanks for the help,
Ted