Recursively parse out specific text pattern

[wbodger]

If I have a field with values such as:

S/M BOX WITH WO# 00287460
S/M BOX WITH WO# 00287460,00341658,00358941
S/M BOX WITH WO# 00287460,00369852

I want to pull each of those work orders out individually, but I do not know how many there may be in each record. So, how would you walk through that field and pull out each 8 digit work order? They will be comma separated and they will always be 8 digits with the first two being 00 for the foreseeable future.

Thanks,
Willie

 

[TamarGranor]

See if this helps:

http://stackoverflow.com/questions/2647/how-do-i-split-a-string-so-i-can-access-item-x

Tamar

 

[fredericofonseca]

if you go with any of the options from the above link I advise you to look at this function

http://www.sqlservercentral.com/articles/Tally+Table/72993/

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886