How to convert a Char value to an Array (SET)

Hi all, I have Char value which is exactly the same as it is an Array and I want to covert it into an array. So I have a variable name chararray(7000) and its value is: set{"and value = '2' and valuecode= 100)","and value = '3' and valuecode=101)"} I can use this chararray in my stored procedure if I can just convert it into the value like CAST(chararray AS set(char(1000)));