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: 15 Mai 2025 10:06:06 von Mario Voigt
Zuletzt aktualisiert: 15 Mai 2025 10:06:15 von Mario Voigt