>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.