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 ...

If you ever need to sort character strings stored in SQL Server fields, check out this demonstration of how to write a common sorting algorithm using SQL Server TSQL code.

In a @Select annotation (and in the others as well) it is possible to write the SQL statement as an array of strings. This is quite handy if one has a multi string SQL and can't use Java 15 with its ...