You can't directly do it with a SELECT statement but once you've got your new table, you can use the UPDATE statement to do what you want:

CREATE #X (c int)

INSERT INTO #x values (1)
INSERT INTO #x values (1)
INSERT INTO #x values (1)
INSERT INTO #x values (1)
INSERT INTO #x values (1)

select * from #x

DECLARE @z int
SET @z=16
UPDATE #x set @z=@z+1, c=@z

SELECT * FROM #x

-Mike

>Hello Group,
>
>Can I increment a field in a select statement.
>
>I have a table with two hundred rows I want to update add my field with values from 300 - 500
>I have a variable name @newvalue
>
>can I write a select statement that will create a new table I.E.
>
>SELECT @NewValue (some increment method) as myuniquefield, name, address
>INTO myNewTable
>FROM myOldTable
>
>Thanks
>Jim