Thank you Jack Corbett

i got it,

can you please tell me how to assign a string to a column Name

like

if the parameterid to be "parameterid"

and how to use the break and continue in this procedure

because when i use the break at last statement near the end ofthe cursor it takes only the first value and nothing is displayed

thank you again