but does SELECT TOP 1 or MAX give me back the value/number in the
field?

I am using a batch and query from the command line with OSQL...

so what I will get back is just a number?

Clustered Index Not Working
Select distinct problems
Top 1 query problem
How to compare two tables of same structure using a hash/checksum
SELECT/INSERT SELECT performance issue