Skip to Main Content

how to tell a list of numbers separated by ';' contains a particular number

Jian-cdoNov 30 2022

Hello,
Assume column study_ID has value like '25:28:29', or '27:28:29' , then I need to get the row value with column A has value of 25. I tried to use Contains, such as "where otherConditions and contains(TBL_MASTER_CONTACT.study_ID,'25',1)>0 ", then it complains about "-10599: column is not indexed" even after I created index on the column. Any clue here? Thanks.

This post has been answered by Frank Kulash on Nov 30 2022
Jump to Answer
Comments
Post Details
Added on Nov 30 2022
3 comments
42 views