Select multiple values EXCEPT one

[#1]

Hi All,

I have problems with my current security setup. I have a list of countries and since we added a new country recently, this new country is limited only to selected users.

ex.

USER_GROUP	COUNTRY
A	*
B	SG
B	JP
B	AM
C	JP

My country lists up to 30+. Since it's a big list, It's not really nice to list everything except the new one. Is there any solution for this?

Thanks!

[#2]

Hi Peter,

Thanks for the suggestion. I will try this out.. hopefully works and I'll tag your answer as correct

Thanks,

Lyn