Search This Blog

Saturday, October 8, 2016

Oralce: SQL to find the BLANK or TAB character in a string.

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:]]$');