!= All may be used inside SQL Statement only

[Matthewbb]

I have a procedure to loop through records from one table with a cursor then initate a insert statement into another table.I am receiving this error in the If Statement "!= ALL" \[code\]If V_Item = V_Item_G And V_New_Part Is Null And (V_Delete_G Is Null or V_Delete_G != 'Y') And Status_G != ALL ('KNOWN', 'NEW, 'UNKNOWN', 'SOLD')THEN INSERT INTO PART VALUES ( V_Item, V_New_Part);\[/code\]--NOTE NOT IN DOES NOT WORK Thanks for the help.