>>>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
I assume that the sequence of text in the field would be Ready for processing, Processing complete. But, adding the wildcard to the beginning and end of each phrase should allow the SELECT to match either phrase properly in any sequence.
Jay