It works, can I put one more question, I am trying to use this to compare with existing string using Match.
Match( 'Shri Manik', 'John A', 'Mac borr', 'Shri Manik') should give me 3 as o/p.
but when I use above as
match( 'Shri Malik', concat(chr(39)&CustName&chr(39),',') )
This returns me 0 always.. How can I use it to find value in string..??