Skip to Content
0
Former Member
Dec 12, 2006 at 01:52 PM

Dynamic select statement

2832 Views

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.