Hi to all,
Anyone could help me out with an update query with split in which one can update the integer value in other column.
E.g.
House No - 125,
Wellington,USA.

Now in the above value is stored in the column named as address and now I want to insert 125 to another column named as houseno using UPDATE Query.

Can anyone help me out in this case.