CONCAT_NULL_YIELDS_NULL
- New
- How-to
-
Anil Rao
- PowerBuilder
- Tuesday, 21 April 2026 09:18 PM UTC
We are migrating from PB/Sybase to PB/SQL Server. In the old Sybase Server/DBs the CONCAT_NULL_YIELDS_NULL setting was turned OFF, so that SELECT NULL + ‘Hello’ would equal ‘Hello’.
In SS, The MSOLEDB Driver (and ODBC as well) automatically issues a CONCAT_NULL_YIELDS_NULL ON when it connects to a database, which overrides the database setting resulting in SELECT NULL + ‘Hello’ would equal NULL.
What is the best place to set CONCAT_NULL_YIELDS_NULL to OFF? We put this after successfully conecting to the DB at the app launch. This seems to be workinig. is this OK/ can we set this at the DBParm in the INI file?
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.