I Have Table like this
I need to Update this table as follows
Here Rows 1,2,3 Contains start id with 123 ie 3,i have to replace with 124 ie 4.... Have to replace 3 as 4.
Would be a very bad idea to update ID's, but if you really must you can use LIKE or SUBSTRING for that. you first need to convert the ID to text, process it, and convert it back.
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)