>How can i convert a string which is col2 in the update statement to a number size 10,2
>
>i am trying to do cint but it is not accepting.
>
>Could you please tell me.
>
>**************************Start************************
>for n = 1 to thisform.pageframe1.page3.list1.listcount
>
> col1 = thisform.pageframe1.page3.list1.listitem(n, 1)
> col2 = thisform.pageframe1.page3.list1.listitem(n, 2)
>
> update actions set sub_id = col2 where sub_key = col1
>
>endfor
>
>*************************END******************************
>
>Thank you.

Raj,

update actions set sub_id = val(col2) where sub_key = col1