Variable field duplicate check

[SNOW39]

How can i check if the text entered in the variable which is a free field text is not repeated. Is there a table that store the value entered in variable of a catalog item.

[Ankur Bawiskar]

Hi,

data for variable is stored in this table; you can query that table with your variable and check if value exists or not

Variable Ownership [sc_item_option_mtom]

Regards
Ankur