SQL中文本字段的“NOT IN”替换

I'm trying detect a new value for a text field. I am comparing the values of the main query with a subquery of old values. Since the field is a text field, I can't use a "NOT IN" clause.I'm trying detect a new value for a text field.