Hi All In a table we need to update data value in a column. To encrypt the data of this column. We have a function that encrypt the data. SELECT fn_generate_enrypt(CardNo) - where CardNo is name column in the table. So we need to update previous data in this table in one go by using this function and <= <ID> column values. I don't know that how update previous data values of column by using this function. Or create dynamic select statement from table for each data values from this column as if run the function like this... SELECT fn_generate_enrpt(1222233334444) then it's work... Pl help here as it is urgent. Thanks in Advance.