I'm getting an error with the following trigger. Please help!
ERROR: Incorrect syntax near '='.
Create Trigger FSP_fullname
SET FullName_ = ISNULL(rtrim(ltrim(ISNULL(FSP_First_Name, '')) + SPACE(1) + ltrim(ISNULL(FSP_SurName, ''))),'READER')
FROM members_mike t
JOIN inserted i ON
t.memberid_ = i.Imemberid_
where members_mike.memberid_ = inserted.memberid_