12d6b889   
   From: reb01501@NOSPAMyahoo.com   
      
   Johnnyb wrote:   
   > On Feb 10, 1:16 pm, "Bob Barrows"  wrote:   
   >> 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   
   >   
   > 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'.   
   >   
   > Thanks   
   Can there be multiple occurrences in the same string? If so, how do you want   
   those handled? Again, show us, don't just describe it.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)