Good question. I interpreted this question to mean that if the old first name was 'Ted,' then include '.Ted.' as well as '.Ted'

WHEREtbl.Body LIKE '%[^a-z]%'+pm.OldFirstName+'[^a-z]%' OR tbl.Body LIKE '%[^a-z]%'+pm.OldFirstName;

IF OBJECT_ID(N'TAB1','U') IS NOT NULL

DROP TABLE TAB1;

CREATE TABLE TAB1 (id INT NOT NULL, num CHAR(3) NOT NULL);

IF OBJECT_ID(N'TAB2','U') IS NOT NULL

DROP TABLE TAB2;

CREATE TABLE TAB2 (id INT NOT NULL, num...

TEST