>Hi,
>
>I have a cursor with three columns. Detail, POSC, POSR
>I am Deleting records from it like This
>
>

>Delete From ABC  Where ;			
>			posC=0 Or ;
>			posR=0 Or ;
>			posR>posRTOPMOSTVALUE Or ;
>			GETWORDNUM(POS,Getwordcount(Alltrim(POS))-3)='(Page'
>
>

>
>I want to Delete Based on above critera, however I Do not want to Delete one record having Detal="ENDP" although it is having corresponding value of posR=0 or posC=0
>
>i.e I want to delete all posc, posr etc based on above but not the record having DETAIL="ENDP"
>
>What additional condition I need to Add on the above
>
>Regards
>
>
>
>
>
>
>Using the above SQL for Delete

Delete From ABC  Where ;			
			(posC=0 Or ;
			posR=0 Or ;
			posR>posRTOPMOSTVALUE Or ;
			GETWORDNUM(POS,Getwordcount(Alltrim(POS))-3)='(Page') AND NOT Detail = 'ENDP'