The || (string concatenation) operator behaves differently when it works with an empty, zero-length string than when it works with NULL, or unknown values.A zero-length character string can be ...

Start date Jul 22, 2002; ... What if the app needs to support UNICODE?<BR><BR>Concatenating strings to make SQL statements invariably leads to hacks trying to make sure the data won't break your SQL.