Hi - could you please advise what and/or how to use the available CB tools/plugins/whatever to ensure that some fields are not entered the same value?
Example: fields for primary (required) + alternative emails; or phone numbers that must be unique: ideally a way to query and return error message if the value already exist.
Thanks!

OK guys, I need to ask probably embarrassing question, but I can't get the query right - the goal is to look for the duplicate values within the same ID - so that if user have entered value into cb_phone1, s/he canno't enter the same value in the cb_phone2.
So the validation is "horizontal" rather than vertical - any thoughts?
thanks!

~~~~~~
(few hours later...) - this is interesting:
I can validate email fields with the query:
and I'm getting the correct results... BUT when I try to do the same with phone fields, nothing... all is ignored.
The difference between the email and phone fields is that I'm using regex on phone:to force the entry: (999) 999-9999
Do you think this can have something to do?

hmm... I can't validate with that email query:
scenario: example:
after user provides the email (the required one), there are 3 more email fields (optional): email2,email3,email4 - so if user attempts to enter the same email address into any of those fields, user should get the error validation.
Now, by no means my sql is perfect, but it does work - I have entered the following variation values under each field's query validation (the "SELECT * FROM `#__users`, `#__comprofiler` " is the same in all queries, only the WHERE portion changes:)

email:
WHERE email=value OR email2=value OR email3=value or email4=value

email2:
WHERE email=value OR email3=value OR email4=value

email3:
WHERE email=value OR email2=value OR email4=value

email4:
WHERE email=value OR email2=value OR email3=value

Please advise - thanks!