SQL Code to out a string's location

Hellow everyone,

Below is my SQL query to find out, do any of the columns (Req_ecCode1 , Req_ecCode2, Req_ecCode3) have the word “YC”. Now my concern is there any way that I can know which columns does “YC” located at?
Hope anyone can help me on this.

select * from SC_Main
where Req_ecCode1 + Req_ecCode2 + Req_ecCode3 like ‘%YC%’

check the below link:

1 Like

Thats helpful, thanks :slight_smile:

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.