I am creating a Linked Server using ASE 15 to Sybase. The field I am selecting is varchar(10). When we run the following query, it always returns len 10 when we only 5 char in the result.
SELECT cparty_category, len(cparty_category)
FROM OPENQUERY (SybaseLink,
FROM table ')
Do you know if there is any setting that will prevent the driver returning with embedded blank?