Thanks Ken Hedges

--Create a test table & insert test record.

Create Table TestSelect (tstField1 Varchar(10), tstField2 Varchar(10), tstField3 Varchar(10))

Insert into TestSelect Select 'A', 'A1', 'A100'

--Cheking the Table

SELECT * FROM TESTSELECT

---------------------------------

----Main query----

---------------------------------

DECLARE @mStrColumns VARCHAR(8000) , @mStrTable VARCHAR(100)

SET @mStrTable ='testSelect'

--

SELECT @mStrColumns = COALESCE(@mStrColumns + ', ', '') + '[' + CAST(SC.[NAME] AS VARCHAR(100) ) +']' ,@mStrTable = schema_Name(schema_id) + '.' + SO.NAME

FROM [SYSCOLUMNS] SC

JOIN SYS.OBJECTS SO ON SC.ID = SO.object_ID

WHERE SC.STATUS <> COALESCE (NULL ,SC.STATUS+1) AND SO.NAME = @mStrTable

--

SELECT 'SELECT ' + @mStrColumns + ' FROM ' + @mStrTable RESULTS

---The results as expected.

--SELECT [tstField1], [tstField2], [tstField3] FROM dbo.TestSelect

--Remember to drop the table afterwards.

Drop table testSelect

Hope this helps.