If you want to be able to test your SQL statements prior to using them in an ASP page, you can use several databases including MS Access, Visual FoxPro, or SQL Server. Each has an environment that allows you to create a SQL statement, and execute it. If instead you are looking for examples, look in either the help for one of the above, or go to your local book store. there are literally hundreds of books available that cover SQL, ADO, etc.