yes, exactly-- and also the field name also without expanding the db name
SELECT [field1], [field2] FROM [Northwind].[dbo].[Customers]
The issue is inconsistency. Sql server enterprise manager generates the brackets, and sql prompt generates the brackets, but if I'm looking through old code they may not be on there. I have to do every search and replace twice because it may or may not have the brackets on there.