If I understand this right you may be looking for..

dbcc checkident('tblName', reseed, 1)

Andrew...know how you must feel but if you incorporate it as part of the "Monday Blues" then it makes it easier to live with...

A...maybe next time you won't be so...

Senthil - if Ryan was online you'd get your solution in a jiffy but since he's not around I'll post his (genius) t-sql...be sure to thank him...

--numbers table
declare @Numbers...

Along these lines...

DECLARE @string VarChar(6)

SET @string = 'abcd'

SELECT 'abcd' + SPACE(6 - LEN(@string)) String, DATALENGTH(@string) BeforePadding, DATALENGTH('abcd' + SPACE(6 - LEN(@string))) AfterPadding

No - he was referring more to the "...and inserts another set of characters at a specified starting point."...

However, you may be better off using "Space()" for your padding...

your post reminded me of a similar one some time back...while all the bonehead movers are fighting to get in their posts first here's an empathetic post to make...

try subtle hints...crank up the volume on the radio...

just out of curiosity...what's your response to "so it's okay to buy that diamond.."?!?!

You would have to use dynamic sql...something like this...

DECLARE @tableName varchar(50)

DECLARE @sql varchar(500)

SET @sql = 'CREATE TABLE ' + @tablename + ' (Col1 Int, Col2 VarVhar(50), Col3... )'

EXEC(@sql)

Seems there's no end to Steve's knowledge-base & talents..

And GPF2^...how nice to have your voice amidst us again...it was so quiet here last week...were...

Sanket - as a favour to everybody (and yourself)...next time please do not cross-post - it is too time-consuming to respond to a post only to find that others have...

You mean something like this...?!?!

select a.* from

(select top 5 nameid, nametitle from tblName

order by nameid desc)a

order by a.nameid

follow thread here

David - just as an FYI - this thread is posted all over the place...here's another thread to follow...

follow thread here

select top 5 nameid, nametitle from tblName

order by nameid desc