SELECT OBJECT_NAME(object_id) AS , NAME

FROM sys.all_columns

WHERE name LIKE '%address%';

worked pulled information ...However as you can tell new to this...What I am looking at doing is finding client names, address,...

Yes got scammed into doing it .....since the other person decide to pursue other work some where else....(Fired)

Yes all the data is in different tables...except client info is located...