This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
There is a simpler solution to this issue. You can use negative lookbehind regex notation.SELECTt1.col1FROMtable1 t1WHEREt1.CATALOG_NUMBER regexp '.+(?<!(_[xX]))$' This will look for "_" followed by any letters present inside the square bracket, in t...