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.