12d6b889   
   From: esquel@sommarskog.se   
      
   Johnnyb (john.lutheran@gmail.com) writes:   
   > Sorry, it is the second answer. I get random entries - like   
   > $8982162:2$905122:2$905PPA:25$9601217:2$962B19:2$CSRI96:2$WDCOLACK:   
   > 2$IDRBLACK2:2$IDRRED:2$. The $'s are delimiters, and I only want to   
   > capture the entires that start with 'WDCO'.   
      
   Use a list-to-table function to convert the entries to table, then you   
   can use a plain LIKE to find the rows that interest you.   
      
   You find several such functions on   
   http://www.sommarskog.se/arrays-in-sql-2005.html   
      
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)