The REMOVE command removes name/values pair from the specified set.
REMOVE expression1, expression2 FROM set
The expressions are evaluated in the context of each product in the Working Set. The string value of expression1 is the name and the string value of expression2 is the value to remove from the specified set. If expression1 evaluates to an empty string, all members of the set are removed. If expression2 evaluates to an empty string, all name/value pairs in the set are removed where the name matches expression1. Otherwise, Any member of the set where the name matches the value of expression1 and the value equals the value of expression2 is removed.
Examples:
WHERE ebay.active LIMIT 1
REMOVE 'Brand', 'Estes' FROM ebay.itemspecifics
LIST
WHERE ebay.active LIMIT 1
REMOVE 'Brand', '' FROM ebay.itemspecifics
LIST
WHERE ebay.active LIMIT 1
REMOVE '', '' FROM ebay.itemspecifics
LIST