Friends,I'm trying to write a select statement that ends like this:and sc.customer_name in (DECODE(shipto,'0',sc.customer_name,shipto));The trouble is that shipto contains a comma delimted list. I ...

T-SQL isn't particularly well suited to advanced string manipulation. I have found that small CLR functions that perform string manipulation and substring extraction perform very well in SQL Server.