16
the intellisense in the 2008 management studio will do this as well as long as you are connected to a SQL 2008 database.
You can change the case you prefer to upper or lower under Tools / Options / Text Editor / Transact-SQL / IntelliSense