I want to match a field value with the values already exist in that field.
Now i am explaining it
suppose my field is f_text.
there are 3 records in the table for these 3 record corresponding f_text values are p,needs,fun.
my requirment is when a new record is created and if i typed fun it must show me error that value already exist but not show me error when a single charcter is typed like n,ne,f............
No doubt it can be done by navigating each record and compare exactly match with the field but i want to use function.
pattern count compare with the single character means when one character will match it shows error.
Just suggest me how to solve it.