Firstly, I am able to import data from Sybase to SQL Server 2000 without a
problem using the Sybase ASE ODBC Driver. Some of the tables in the
Application database on Sybase have literal field names timestamp and time,
which are reserved words on MSSQL, therefore when using a query within the
import, I am unable to protect those field names or cast or convert those
fields.

Here is an example of a query that works with no errors, but not actually
works:

select Timestamp,ApplicationID,Application,CallsAbandoned ,Time,SiteID,Site
from blue.dbo.iApplicationStat

But when adding the protection for fields you are not able to due to odbc
errors and am not able to run any functions on it either:

select
[Timestamp],ApplicationID,Application,CallsAbandoned,[Time],SiteID,Site from
blue.dbo.iApplicationStat

Bottom line is I want to be able to place in the select statement a where
clause condition and I know this is kind of a long drawn out question, but
has anyone had any experience in this?


Any help would be greatly appreciated.

Thanks

Jeff