LibreOffice Base SQL for No Spaces in Strings

USE TRIM() TO prevent ONLY spaces IN a text FIELD WITH a CHECK CONSTRAINT:

CONSTRAINT NOSPACES_CK CHECK(TRIM(BOTH FROM <field>) <> '')

FULL Example:

CREATE TABLE "MyTable" (
"ID" INT PRIMARY KEY,
"Name" VARCHAR(50) NOT NULL,
CONSTRAINT NOSPACES_CK CHECK(TRIM(BOTH FROM "Name") <> '')
);

The BOTH FROM can also be LEADING FROM OR TRAILING FROM TO GET the LEADING OR TRAILING spaces.

Note that LEADING FROM IS the same AS USING LTRIM AND TRAILING FROM IS the same AS USING RTRIM.