Database

select Col,[Col[1]] from Test

Mycroft Holmes wrote:

Who would be dumb enough to use reserved words or characters in a column name.

Mycroft Holmes wrote:

Doing that is akin to sticking your finger in the power point, may not kill you but your fingers gonna sting for a while.

Mycroft Holmes wrote:

So did the extra set of brackets work?

declare @t table(Company_Name varchar(50))
insert into @t 
	select 'ComxxxA Co.' union all select 'ComxxxA Co.' union all
	select 'ComxxxA Co.,Ltd.' union all select 'ComxxxA Co.,Ltd.' union all
	select' ComxxxA Co.,' union all select 'ComxxxA Co.,' union all
	select 'ComxxxA ' union all select 'ComxxxA ' union all 
	select 'Comx' union all select 'ComxxxxxxxB Co.,Ldt' union all
	select 'ComxxxxxxxB Co.,Ldt' union all select 'ComxxxxxxxB Co.,Ldt' union all
	select 'ComxxxxxxxB Co.,Ldt' union all select 'ComxxxxxxxB Co' union all
	select 'ComxxxxxxxB Co.,' union all select 'ComxxxxxxxB Co.,'

select  Company_Name
from @t 
where replace(Company_Name, ' ','') not like '%[.,]%'
group by Company_Name 

Company_Name
Comx
ComxxxA 
ComxxxxxxxB Co

ALTER TABLE dbo.tablename ADD CONSTRAINT
	DF_TimeStamp DEFAULT '20091218' FOR TimeStamp

Ashfield wrote:

How about defining a default value for the column?

select column_list....
from table1 t1
where indicator > 30
and exists (select 1 from table1 t2 where t2.pk = t1.pk and t2.indicator < 30 and t2.dateadded = dateadd(day,-3,t1.dateadded))