cancel
Showing results for 
Search instead for 
Did you mean: 

charpos() function in calculated column

saurav123
Explorer
0 Kudos

I want to know if a substring is present in a string in a calculated column in a cal view. So, i want to try for charpos() function but i can not understand how it is working ... i know there is one more function locate() in sql engine for a calculated column but i can not use it because i want to use if() function also and once i will change option to SQL engine, if() function will not come ... so kindly explain me about the functionality of charpos() function or is there any other alternate method to check the presence of substring in a string in column engine for a calculated column.

View Entire Topic
pfefferf
Active Contributor

You can use the instr function for your requirement, liked described here.