In a stored procedure, have input field varchar(200), see below table. Try to get output1 and output2 declare as varchar(200). Output1 will be distinct left of ‘:’ and Output2 will be distinct right ‘:’. Both Output1 and Output2 will be use in a IN statement.
Thank you for helping!!