Your question is very unclear.
Maybe you mean something like.
SELECTMAX(Val)
FROMTable
WHEREVal < (SELECT MAX(Val) FROM Table)
For better, quicker answers on T-SQL questions, read
Jeff Moden's suggestions.[/url]
"Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort