I have a table with 2 columns id & name(unique key).
Name column has values as firstname space lastname.
before inserting new row I want to ensure that substr of newname
should not match with substr of any name in the table .
substr is to be upto 1st charater after space "substr(name,1,instr(name,' ')+1)".
Can someone please help me with trigger before insert.
Thanks in advance.