>Almost. The problem is that it shows records that have both "Ready for processing" and "Processing completed" values. I can only show those rows that do not have "Processing completed" values, ie I need to filter out the rows that have actually completed.

Select iBatchID , cFileName , cStatusDesc From xxx ;
>> Where cFileName like '\\vanbustest\SCCFiles$\scc\staging\dev\standard\01102301.120%' ;
>> and cStatusDesc like 'Ready for processing%' ;
and cStatusDesc not like 'Processing complete%'
>
>
>Jay

Sorry, I didn't read that a row could have 2 values. Will this work?

Jay