olá

tente algo como:

select * from clientes where codigo < 209394 TOP 1 ORDER BY codigo desc

isso deve resolver.

[ ]'s

Leandro Walfrans
VolpeCOM