Pervasive SQL Union throwing Error

Here's a union statement I wrote:

SELECT  convert(' Type or Select from Dropdown List', sql_varchar) AS DisplayLocNo,
                convert(' Type or Select from Dropdown List', sql_varchar) AS DisplayName,
                convert(' Type or Select from Dropdown List', sql_varchar) AS DisplayDbaName,
                CONVERT(- 1, sql_integer) AS Loc_No, CONVERT(20, sql_integer) AS Dba
FROM CL_MAST
UNION
SELECT  ltrim(rtrim(CONVERT(Loc_No, sql_varchar) + ' - ' + LTRIM(RTRIM(Name)))) AS DisplayLocNo,
                ltrim(rtrim(LTRIM(RTRIM(Name)) + ' - ' + CONVERT(Loc_No, sql_varchar))) AS DisplayName,
                ltrim(rtrim(LTRIM(RTRIM(Dba_Name)) + ' - ' + CONVERT(Loc_No, sql_varchar))) AS DisplayDbaName,
                CONVERT(Loc_No, sql_integer) as Loc_No, LENGTH(Dba_Name) AS Dba
FROM CL_MAST CL_MAST_1
WHERE (Delete_Date IS NULL)
order by 4

It runs fine under version 8 after I added convert around the literal strings in the top part of the union.  In version 10, I get "[LNA}[Pervasive][ODBC Engine Interface] More than one unlimited size column in Distinct, Order By, Group By, or Union."
I've tried changing to cast and setting the size, but that didn't work.  I'm open to suggestions.
Thank you in advance for any help you can provide.

I'm new to Pervasive, but I'm an old pro when it comes to Oracle or SQL Server.
Sincerely,
Bruce Edgar
email: bedgar@aeshr.com
Start Free Trial