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.
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.
Comment