Dmitry,

You can have one SQL statements and use TEXTMERGE() to replace incompatible parts.

lcSQLTemplate = "SELECT filed1, field2, <<lcNVLfunc>>(field3, 0) FROM mytable"
lcNVLfunc = "NVL"
? TEXTMERGE(lcSQLTemplate)
lcNVLfunc = "ISNULL"
? TEXTMERGE(lcSQLTemplate)

>I didn't know it. Thanks. I wish there was also equivalent of NVL() to Sql Select so that I would not have to have 2 SQL Select statements for each database.