Steven,
You could create a unique (or candidate) index on the field and then just try to insert the new data. When you don't get an error it's OK; be sure to write code to catch the possible error.