I want to create dynamic select statement I have following scenario
I have a table with fields
Table name
Field name to select
Restriction
Consider I have following data in that which can change I mean users wish to enter data in it.
SELECT (Field name to select)
INTO temp
FROM table name
WHERE Field name to select = restriction.
My problem is how to build a select where I only have name of the field.
Please reply as soon as possible.