Thge thing is....You do not know which variables can be created, because they can be different per project. For instance:

Proj 1 - Address, City, State

Proj 2 - Phone Number,...

The queried table contains field names (Address, City, State). Previously in some dynamic SQL code, a concatenated string declaring all of these as variables was used (Ex: @dr_Address varchar(50), @dr_City...

This solution had nothing to do with my problem. I just need to retrieve the value within a dynamically created variable instead of the program thinking I want to...

Well, this is only part of the code. Everything else works. I just need to figure out how to retrieve the value within the concatenated created variable. and...