FIND_IN_SET Function - How to find position of string in Comma separate values list01-02-2019 0 Comment(s)
FIND_IN_SET function is used to find the position of string in list of comma separated values. FIND_IN_SET can return depending upon the searched value and values present in comma separated list.
- Either StringToFind or Comma_Separated_String_List is null, then output is going to be null for find_in_set.
- Find_IN_Set will return zero if the StringtoFind is not present in Comma_Separated_String_List.
- If StringtoFind is present in Comma_Separated_String_List then positive number will be returned.
Below is example that covers all above scenarios or result set returned by find_in_set.
No Comments to Show