I'm assuming that the 'Val4Coln' comes from the calling program? If this is the case, can you not build your lists in your calling program and pass them as parameters?

If this is not the case, nevermind.

>Hi,
>
>In a stored procedure I have a hard coded Insert expression:
>

>insert into mytable (col1, col2, col3) values (@Val4Col1, @Val4Col2, @Val4Col3)
>

>
>Since the list of columns and values has to be built dynamically, I need to be able to create
>this expression based on variables. E.g.
>

>declare @FieldNames as varchar(max)
>set @FieldNames = 'col1, col2, col3'
>-- and I can't even figure how to concatinate the list of values into a variable
>

>
>So, is it possible to create a variable for list of values and then combine it with the variable for the list of columns and
>execute the INSERT? TIA.