>>
>>You can build SQL statement as a local string variable and than run it using EXECUTE command or sp_executesq system sproc. For example,

DECLARE @Sql varchar(4000)
>>SET @Sql = 'SELECT fld1 FROM [' +  @lcTableName + ']'
>>EXECUTE (@Sql)

>
>How are you able to use '[' and ']' w/o getting an error?

Why would I get an error? The square brackets are legitimate delimiters for SQL Server identifiers. The double quotes can also be used if SET QUOTED_IDENTIFIER is set to ON. See BOL for details.