How to get back the current count of a auto incrementing number.

hi

     How to get the current value of a auto
incrementing number generated using CREATE SEQUENCE
seqname START 1

Is there any way and if yes what is it. Can we run a
select query and may be a inbuilt function which will
return the current value of that number?

Regards.



__________________________________
Do you Yahoo!?
Yahoo! Mail - Find what you need with new enhanced search.
http://info.mail.yahoo.com/mail_250