I need a query to find all records that has "does not meet the requirement:" in the Fault_Message Field...See Table below...Thanks
[TABLE="width: 1080"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]SITE_ID[/TD]
[TD]ACCOUNT[/TD]
[TD]Bill Day[/TD]
[TD]FAULT_MESSAGE[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]14779802[/TD]
[TD]1[/TD]
[TD]ICB0350:CBM3700:Service EE200 does not meet the requirement: 1B Include if all[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]711424601[/TD]
[TD]1[/TD]
[TD]ICB0350:CBM3700:Service ML256 does not meet the requirement: 1A Include if one[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]722692602[/TD]
[TD]1[/TD]
[TD]ICB0350:CBM3700:Service ML257 does not meet the requirement: 1A Include if one[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]705159001[/TD]
[TD]1[/TD]
[TD]ICB0350:CBM3700:Service ML267 does not meet the requirement: 1A Include if one[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]466843501[/TD]
[TD]1[/TD]
[TD]ICB0350:CBM3700:Service ML455 does not meet the requirement: 1A Include if one[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]8052303[/TD]
[TD]1[/TD]
[TD]ICB0350:CBM3700:Service ML987 does not meet the requirement: 1A Include if one[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]30808708[/TD]
[TD]1[/TD]
[TD]ICB0350:CBM3700:Service ML987 does not meet the requirement: 1A Include if one[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]347946901[/TD]
[TD]1[/TD]
[TD]ICB0350:CBM3700:Service ML987 does not meet the requirement: 1A Include if one[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]458678001[/TD]
[TD]1[/TD]
[TD]ICB0350:CBM3700:Service ML987 does not meet the requirement: 1A Include if one[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]451897302[/TD]
[TD]1[/TD]
[TD]GatewayError: RC=9999, MSGNO=CBM5578, MSGTEXT=Account must be active, or must have a pending Install WO., SourceLocation=ICB0312 OrderException_1{#0,Key=null,ReturnCode=9999,MessageNumber=CBM5578,MessageText=Account must be active, or must have a pen[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]463648202[/TD]
[TD]1[/TD]
[TD]GatewayError: RC=9999, MSGNO=CBM5578, MSGTEXT=Account must be active, or must have a pending Install WO., SourceLocation=ICB0312 OrderException_1{#0,Key=null,ReturnCode=9999,MessageNumber=CBM5578,MessageText=Account must be active, or must have a pen[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]731785501[/TD]
[TD]1[/TD]
[TD]GatewayError: RC=9999, MSGNO=CBM5578, MSGTEXT=Account must be active, or must have a pending Install WO., SourceLocation=ICB0312 OrderException_1{#0,Key=null,ReturnCode=9999,MessageNumber=CBM5578,MessageText=Account must be active, or must have a pen[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 1080"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]SITE_ID[/TD]
[TD]ACCOUNT[/TD]
[TD]Bill Day[/TD]
[TD]FAULT_MESSAGE[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]14779802[/TD]
[TD]1[/TD]
[TD]ICB0350:CBM3700:Service EE200 does not meet the requirement: 1B Include if all[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]711424601[/TD]
[TD]1[/TD]
[TD]ICB0350:CBM3700:Service ML256 does not meet the requirement: 1A Include if one[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]722692602[/TD]
[TD]1[/TD]
[TD]ICB0350:CBM3700:Service ML257 does not meet the requirement: 1A Include if one[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]705159001[/TD]
[TD]1[/TD]
[TD]ICB0350:CBM3700:Service ML267 does not meet the requirement: 1A Include if one[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]466843501[/TD]
[TD]1[/TD]
[TD]ICB0350:CBM3700:Service ML455 does not meet the requirement: 1A Include if one[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]8052303[/TD]
[TD]1[/TD]
[TD]ICB0350:CBM3700:Service ML987 does not meet the requirement: 1A Include if one[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]30808708[/TD]
[TD]1[/TD]
[TD]ICB0350:CBM3700:Service ML987 does not meet the requirement: 1A Include if one[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]347946901[/TD]
[TD]1[/TD]
[TD]ICB0350:CBM3700:Service ML987 does not meet the requirement: 1A Include if one[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]458678001[/TD]
[TD]1[/TD]
[TD]ICB0350:CBM3700:Service ML987 does not meet the requirement: 1A Include if one[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]451897302[/TD]
[TD]1[/TD]
[TD]GatewayError: RC=9999, MSGNO=CBM5578, MSGTEXT=Account must be active, or must have a pending Install WO., SourceLocation=ICB0312 OrderException_1{#0,Key=null,ReturnCode=9999,MessageNumber=CBM5578,MessageText=Account must be active, or must have a pen[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]463648202[/TD]
[TD]1[/TD]
[TD]GatewayError: RC=9999, MSGNO=CBM5578, MSGTEXT=Account must be active, or must have a pending Install WO., SourceLocation=ICB0312 OrderException_1{#0,Key=null,ReturnCode=9999,MessageNumber=CBM5578,MessageText=Account must be active, or must have a pen[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]731785501[/TD]
[TD]1[/TD]
[TD]GatewayError: RC=9999, MSGNO=CBM5578, MSGTEXT=Account must be active, or must have a pending Install WO., SourceLocation=ICB0312 OrderException_1{#0,Key=null,ReturnCode=9999,MessageNumber=CBM5578,MessageText=Account must be active, or must have a pen[/TD]
[/TR]
</tbody>[/TABLE]