Okies, Now i get the Row Numbers from you query.

But i have a small silly doubt again on this,

How can i show the ID (which is more than 8 digit)...

The tbl is a varying table, sometimes it will have 100, sometimes 1000,

As of now it is having 150 Datas. (means 150 IDs in the sequence which i...

Hi Chris,

Thanks for you response, when i executed, i get below result.

IDIDx

0306

1224

1326

1836

1938

2346

2550

But in realtime, I have a column named ID and the...