Getting a number from a select max statement?

[Stegmite]

I'm trying to get the highest number in a column, then add 1 to it (for unique contraints).

SELECT MAX(USER_ID) FROM CLIPR.USERS;

How can I get the number that this comes up with?

 

[RiverGuy]

Ummm, is this a VB.Net question? The simplest way would be to create a Command Object (either SqlCommand, OleDBCommand, OracleCommand; whichever applies) and assign the .ExecuteScalar() function of it to a variable.