My dilemma is that the query has to have the ability to cope with either one of three formats:

1) a normal 10 chracter string 'xxxxxxxxxx'

2) a 10 character string containing...

Good Luck!!

Hi Paul

That's fantastic! .. worked a treat 🙂

Many Thanks

Sean

Thanks for that I think I understand. However, the resulting data needs to populate a 3 column table:

Col 1 - poit_supplier (Supplier Code - to be output only once for...