1. Try SQL like "... WHERE CODE > 'NE1' AND CODE < 'TS15'" -- It works for Last Names on a SQL Server 2000 db I have.

2. Well, ASP has no way of knowing when the browser closes, but you could have them keep opening pages - you could use a frameset, and have one of the frames refresh every few minutes.