thanks

Im stuck at another thing now

I have to do this conversion for all rows in the table

if i write select @string=str_col from tbl1

follwed by all the other string conversion statements;it gives me only the first row

How do i write the select command in the stored procedure statement to run for all rows in the table?