>I am using a Sybase ASA database version 8.02. Here is the select statement I am sending to the database. Im my testing I found the problem only when using the coalesce()function as part of the select. This is the same as the nvl() in foxpro.
>

Try to add NULL as last parameter for COALESCE. I am not sure about Sybase, but it works for SQL Server.

COALESCE (reportpref.printer,'Default',NULL) as cPrinter ,

Thanks,
Aleksey.