If word in column A starts with letters in column B then in SQL

select ColumnA, ColumnB, (Case When SUBSTRING (ColumnA, 1, 2) = ColumnB Then 'Yes' Else 'No' End) as ColumnC from Elements

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top