I've been using MS Access with ASP, connecting via ODBC and I've been using the Access functions (i.e. "IIF") in my SQL statements in the ASP code. <BR><BR>Can I use T-SQL functions (i.e. CASE WHEN ...) in a SQL statement in my ASP code when connecting to MS SQL Server, or is T-SQL restricted to Stored Procs?? If it is restricted, what can I use?<BR><BR>What else do I need to know about upsizing?