I hope I can explain this:
If I have a string or row of information like WT BY HG DFG KJL I would like to store it in one word like Baggage. The purpose: This will make it easier for me to write queries instead of using IFF Then Else Statements.
All the strings I have has several different letters in it and all of them needs to be converted into a simple word. Any ideas?. Also, I have a decode table with the definitions in it if this helps.
Thanks for your time.
If I have a string or row of information like WT BY HG DFG KJL I would like to store it in one word like Baggage. The purpose: This will make it easier for me to write queries instead of using IFF Then Else Statements.
All the strings I have has several different letters in it and all of them needs to be converted into a simple word. Any ideas?. Also, I have a decode table with the definitions in it if this helps.
Thanks for your time.
