Filter out anything that comes before a certain text in a query

[xmattxman]

I have a query shown below. I need to filter out everything before Disposition and just pull out the line that starts with disposition and every line after that. I cant really use the line # as a criteria because that line number is different depending on the amount of text before it. Disposition will always be the last lines in the query results if that helps. Any ideas on how this could be done?

CURRENT QUERY
OH_NUMBER
NL_LINE
NL_LINE_NO

0003556


1

0003556
Original  Job #: C# 008
2

0003556


3

0003556
Reason: PART WAS ON ORDER BUT RECEIVED 40 PIECES OF
4

0003556
AND WRONG INSPECTION PAPER.
5

0003556


6

0003556
Evaluation: WRONG ITEM SHIPPED
7

0003556


8

0003556
Cause:
9

0003556


10

0003556
Corrective Action:
11

0003556


12

0003556
Disposition:WE SHIPPED THEM THE CORRECT ITEM AND HAVE 
13

0003556
ALREADY CREDITED THIS ITEM THROUGH THE ORDER. 
14



OUTCOME I AM LOOKING FOR
OH_NUMBER
NL_LINE
NL_LINE_NO

0003556
Disposition:WE SHIPPED THEM THE CORRECT ITEM AND HAVE 
13

0003556
ALREADY CREDITED THIS ITEM THROUGH THE ORDER. 
14



Current SQL
SELECT OH.OH_NUMBER, PK1_NL.NL_LINE, PK1_NL.NL_LINE_NO
FROM OH INNER JOIN PK1_NL ON OH.OH_NMSEQNUM = PK1_NL.NL_NMSEQNUM;

[ranman256]

Q1 = select *, instr(NL_LINE, "Disposition") as iStart from table where instr(NL_LINE, "Disposition")>0
Q2 = select [OH#] ,mid(NL_LINE,[Q1],iStart) from Q1

run Q2.
Q1 pulls recs that have Disposition,
Q2 pulls everything Right of the word

[xmattxman]

When I run Q2 it prompts me for Q1 Parameter Value?

[June7]

Reference to query object in Mid not valid. Try removing it.