Thanks for all the suggestions, I learned something from each one of them. I ended up using the DBCC InputBuffer command.

To clarify, yes, I was trying to capture the names...

Clint - thanks for clarification.

select max(salary)-1 from table_name