Ashish Agarwal

DECLARE @commaSeperatedCols VARCHAR ( MAX ) DECLARE @TableName VARCHAR ( 100 ) SET @TableName = 'Your_Table_Name' SELECT @commaSeperatedCols = COALESCE ( @commaSeperatedCols + ',' , '' ) + COLUMN_NAME FROM INFORMATION_SCHEMA . COLUMNS WHERE TABLE_NAME = @TableName SELECT @commaSeperatedCols

Declare @i int , @loop int , @str varchar ( 100 ) = 'TEST_lOwerCase' IF EXISTS ( SELECT * FROM tempdb . dbo . sysobjects WHERE ID = OBJECT_ID ( N'tempdb..#Temp' ) ) BEGIN DROP TABLE #Temp END create table #Temp ( id int ) select @i = LEN ( @str ) print @i set @loop = 1 while ( @loop <= @i ) BEGIN       if (( ascii ( SUBSTRING ( @str , @loop , 1 ))>= 97 ) and ( ascii ( SUBSTRING ( @str , @loop , 1 ))<= 122 ))       insert into #Temp values ( @loop )       set @loop = @loop + 1 END select MIN ( id ) from #Temp GO