Writing an autocount Query

Hello All,<br /><br />I am stumped (which really isn't that hard to do <img src='/community/emoticons/emotion-1.gif' alt='' /> )<br /><br />I am trying to write an update query to insert into a varchar colum this text D6_ with the underscore followed by and auto incrementing number up to 641 so the final product should appear as so in the colum: D6_1<br /> D6_2<br /> D6_3<br /> etc.<br /><br />so far i have this part of my query written<br /><br />UPDATE (table)<br />SET (colum name) = 'D6_' +<br /><br />and that is it (yes i have completed all the easy stuff myself <img src='/community/emoticons/emotion-1.gif' alt='' /> ) i have researched using the CURSOR, CAST and CONVERT arguments (because i have a int colum in the same table that i could relate to for the "counting") but to no avail. does anyone have any insight into what *should* be a suuuuuuuuuuuper easy query to write?<br /><br />Thank you all so much in advance!

There is one table and in that table are 641 records I only want to populate one field/colum of said table with the syntax described above, think of the displayed D6_ as the indentifier as to what "book" is being used and the numbers proceeding the underscore as book page numbers for each index that is being cycled through in the utility program that uses the DB.