Find ugly document titles

This statement looks for titles with unrequired whitespace duplicates

/*title which contain doubled whitespaces*/
SELECT
    doc_title_c
FROM t_document
WHERE
    LENGTH(RTRIM(LTRIM(doc_title_c))) <> LENGTH(doc_title_c) OR
    doc_title_c LIKE '%  %' AND
    doc_deletedate_d IS NULL
;

Version #1
Erstellt: 2025-05-15 10:06:06 CEST von Mario Voigt
Zuletzt aktualisiert: 2025-05-15 10:06:15 CEST von Mario Voigt