Database

Naveed Kamboh wrote:

I have already that data in varchar there 10,000+ records which containt these foreign characters.
When we search using english chracters they do not come in the search.

insert into table1(cola, colb,.....)<br />
select case when datalength(valuea) = 0 then null else valuea end, case when datalength(valueb) = 0 then null else valueb end  .....

Alsvha wrote:

SELECT Name, Count(Count)) as cnt FROM NameTable1

/* set up example */<br />
create table #b1(cola int)<br />
<br />
declare @a int<br />
<br />
set @a = 0<br />
<br />
while @a < 10<br />
begin<br />
	insert into #b1 select @a<br />
	select @a = @a +1<br />
end<br />
<br />
set @a = 4<br />
while @a < 10<br />
begin<br />
	insert into #b1 select @a<br />
	select @a = @a +1<br />
end<br />
<br />
/* show the desired query */<br />
select cola,count(*),(select count(*) from #b1) <br />
from #b1<br />
group by cola<br />
<br />
/* tidy up */<br />
drop table #b1

declare @total int<br />
<br />
select @total = count(*) from #b1<br />
<br />
select cola,count(*),@total<br />
from #b1<br />
group by cola