>Thank you, Naomi. My old favorite ALLT failed to work.
If you read my article you would know that using ALLTRIM() in SQL comparison to account for trailing spaces can produce unexpected results and is not necessary. It also can make the query unoptimized or require to keep unnecessary indexes.
--sb--