on 08-14-2020 8:43 AM
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.
You can use the instr function for your requirement, liked described here.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
79 | |
11 | |
7 | |
7 | |
7 | |
6 | |
6 | |
6 | |
6 | |
6 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.