Retrieve rows from a table where part of the text in a column field matches the text from another table

>> tblFullName [sic] has a column called FullName which contains full names, and tblLastName [sic]

So many errors in this narrative! The prefix “tbl-” is so silly it has the name “tibbling” when we talk about design flaws. The goal of DBMS was to remove redundancy. This is basic and you should know it.

>> What is the T-SQL to accomplish this? <<

SQL is not a text or semantic language. We do this by using a tool designed for names; I like Melissa Data for names.

---

--CELKO-- Books in Celko Series for Morgan-Kaufmann Publishing: Analytics and OLAP in SQL / Data and Databases: Concepts in Practice Data / Measurements and Standards in SQL SQL for Smarties / SQL Programming Style / SQL Puzzles and Answers / Thinking in Sets / Trees and Hierarchies in SQL