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
;
Keine Kommentare