Thanks
I will give it a try.
>>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.