> something like this; SELECT currval('blahseq') > > I want to be able to set an object name for this value which > is different > to the field name that the SQL will return. SELECT currval('blahseq') AS myname should return a column named 'myname'. Julian.