Below is the SQL that can be used to identify the BLANK characters or TAB characters present at the end of the string.
SELECT UPPER(ADDRESS1),EMPLID FROM PS_ADDRESSES
WHERE regexp_like(ltrim(UPPER(ADDRESS1)), '[[:space:]]$');
SELECT UPPER(ADDRESS1),EMPLID FROM PS_ADDRESSES
WHERE regexp_like(ltrim(UPPER(ADDRESS1)), '[[:space:]]$');
No comments:
Post a Comment