Here is my problem, in my database, lets say I have the following data.  The
underscores(_) are spaces.

fieldCode
001
001
001

fieldDescription
Computers_Desktop
Computers_Desktop
Computers_Desktop_________________

Using SQL 6.5 Enterprise manager, I do the following query...

"SELECT DISTINCT fieldCode, fieldDescription WHERE fieldCode = '001'"

and it yields this result...

001, Computers_Desktop

This is what I want.  But when I do it from an ASP using VBScript and an
ODBC connection, I get the following...

001, Computers_Desktop
001, Computers_Desktop_________________

I get Computers_Desktop listed twice when I only want it once.  It sees
trailing spaces as part of the data which makes it distinct where SQL
Enterprise Manager doesn't.  This is causing a real problem.  Can anyone
tell me how to get around it without modifying the data in the database?
Which has the error, vbScript and ODBC or SQL Manager?

Thanks in advance.

Craig Kohtz
http://www.*-*-*.com/