>>I have a table with a status column value of "Ready for processing..." or "Processing complete...". Some rows have both values, others have just the "Ready for processing..." value. I want to find those rows that just have the first value. But I can't use group by or having. Can anyone recommend a fast way to get around this?
>>
>
>Steve,
>
>Is this what you're looking for?
>
>>

>>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