Thanks, I will look into those.
>There're two possible workarounds
>
SQL 2000 ODBC driver but all new data types will not be available
> CA with ADO
>>
>>Recently have been querying a SQL Server table that contains VARCHAR column types. I am using the SQLExec method to Select a subset of data. If the first row has an empty Varchar column, the resulting column is created with a zero length Character type. I have tried set the VARCHARMAPPING setting, but it did not alter the results. The routine that performs this operation is fairly generic and none of the columns are directly referenced, so forcing the column to be padded is the lowest of the options (?).
>>
>>Is there anyother options I may be overlooking? Any in the SQL options?
Greg Reichert
