Good morning folks- I have a table that has a 13 digit field, the last two numbers are a sequence number, I need to find all records that have a 99 code (which is an error in this application) and list the record# and all previous sequences in that number...
An example of the number could be
in this example the record# 1111111111111 has 4 different "Sequences"
I need to find all the ones that have a 99 sequence and I want to see what other sequences are under that same number (in my above example I would want to select the 21111111111111 record because it has a 99 sequence and I want to list out all the other sequences for that record(01,02)
In a perfect world I would have the record number and then the sequence separated
2111111111111 - 01
2111111111111 - 02
Doing a mix using something simple like a substr I am only getting the 99 sequence, not all the others....
I know there is some very simple answer I'm just overlooking it and trying to over complicate it...