I have a table with HomeStudent1 and need a trigger which should check for the record if the datalength(stunotes) = 20
if exists then it should insert that record to FacultyStudent2
and delete that record from HomeStudent1
Table: HomeStudent1
stid varchar(40),
stname varchar(20),
stunotes text
Table: FacultyStudent2
stid varchar(40),
stname varchar(20),
stunotes text
Thanks for your help in advance