I need to run a update query to change the information in a field that will have text appened with a number increments.
Example
first record would be: text_01
secound record woulbe be: text_02
last record would be: text_03
So far I have this:
Update text Set text_id = "text_" + (select count(*)from text) + 1;
I know that the select * has to be a variable to work... I think..
Any help would be appericated.
Thanks
Dwayne
Example
first record would be: text_01
secound record woulbe be: text_02
last record would be: text_03
So far I have this:
Update text Set text_id = "text_" + (select count(*)from text) + 1;
I know that the select * has to be a variable to work... I think..
Any help would be appericated.
Thanks
Dwayne