5a275440   
   From: reb01501@NOyahooSPAM.com   
      
   Johnnyb wrote:   
   > I receive this data in a column in a table:   
   > $8982162:2$905122:2$905PPA:   
   > 25$9601217:2$962B19:2$CSRI96:2$WDCOLACK:2$IDRBLACK2:2$IDRRED:2$   
   >   
   > I need to make a view that will keep only the entries in that string   
   > that start with 'WDCO' and omit the rest   
   >   
   > So I need to edit text in the process of copying the data from the   
   > table to the view. Hope this makes sense, sorry, I'm a newb.   
   >   
   > SQL 2008 with patches.   
      
   Please show us exactly what you want to extract from that string in addition   
   to attempting to describe/explain it. Based on your description, you want   
   the query/view to return:   
   WDCOLACK:2$IDRBLACK2:2$IDRRED:2$   
      
   Is that your intent?   
   Or do the $ symbols represent delimiters for "entries" in the string, in   
   which case this is what you want to return:   
   WDCOLACK:2   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)