🚀 go-pugleaf

On Wed, 20 Jan 1999 22:10:59 +0100, "Jens Korth" <XJens.KorthX@wanadoo.fr>
wrote:

>OK, upper and lower does not work in SQL statements with memofields.
>So I assume that it is also a "feature" that memofields do not work for a
>string concatenation:
>
>select memofield1||memofield2  as test from ..........

None of the SQL string functions and the CAST function work with memo or
BLOB columns in local SQL. Use of functions like UPPER and LOWER did work
under 16-bit BDE, but that was because SQL was simply translated to
(Paradox) QBE for execution. When the 32-bit version of the BDE came out, a
true SQL engine was used. The primary reason for this was better compliancy
with the SQL-92 specification, but it also introduced some functionality
changes.

The functions below work with CHAR columns, but cannot be used with memo
columns.

  CAST
  concatenation function (||)
  LOWER
  SUBSTRING
  TRIM
  UPPER

//////////////////////////////////////////////////////////////////////////
Steve Koterski                       "For people who like peace and quiet:
Technical Publications               a phoneless cord."
INPRISE Corporation                                             -- Unknown
http://www.inprise.com/delphi