help autoincreasement

[tinytree]

how can i get a result from a table by query ,result has a new column include autoincreasement
talbe data:
testa b
test2 c
dldllld dd
query result :
1 testa
2 test2
3 dldllld

[RuralGuy]

Here's a link that should help.

[tinytree]

Here's a link that should help.

thank u , I am poor in english . the link displays use a public user define funtion in the sql.could u give me a link of all access inner fuction that can used in query.
thank u a lot again.
this answer let me konw that I can use public function in my sql.isn't it?

[RuralGuy]

Most Public Function are available for use in a query. I'm not sure what you are asking.

[tinytree]

Thank you.
Inner function are are available for use in a query ,for example max,min ,left,right,mid......and so on .but we can use ours defined function embed in a sql ,just like you give me the link.
Thanks again.

[RuralGuy]

Are you saying that you implimented the link I gave you and it did *not* work as advertised? I've used it and it works.

[tinytree]

Now,it works. thanks

[RuralGuy]

Great. How about using the link in my sig?