Comparing Column's Value with Other Column and Based on Condition Choose Value from Third Column SQL

Extracting Unique Characters within a Field in SQL Using Regular Expressions and Substring Functions