Lookup String

[macca]

I have a 67 binary code string produced from a query which concatenates these 1's and 0's.

What I need to do is have access decide what a particular string value/range is and return the process name. e.g

1100000000000000000000000000000000000100001000000000000000000000001. The process name would be COMP RESOLVED MSA


1010000000000000000000000000000000000100001000000000000000000000001.The process name would be COMP UNRESOLVED MSA

0000000000000000011101000000011000000000000000000000000000000000001

The process name would be MSA NEW

There could be about 60 different Process Names

 

[Bat17]

build a lookup table with the 60process names and their 67 charecter numbers and link them in to the main query to return the process names

HTH

Peter