How to Exec variable contenting SQL statement in Procedure?

[Tuan Nguyen]

I have one procedure Such as:
create procedure (in Fieldname varchar(100))
begin
declate SQL varchar(200);
set SQL='select '+Fieldname+' From Table1 where CodeID=0001';
Exec SQL;
'here i want to exec SQL variable SQL the same SQL server, but i can not
end
-I need so much, Help me, thanks.