thank you. that's what I was thinking to do. I appreciate your help. it is going to help us a lot.

regards,

Navie

one more thing. how I can add to get only results if they are not null or zero. in other words, populate table with results 1 or more.

thanks,

thank you very much. it work the way I want to see.

thank you!

it is very close , but in results, it is only showing

TotalChar013. it 's not showing tablename, servername, column name etc.

if I get this, that will solve my...

thanks, it didn't work. let me explain again. My first query gives me results fine for one column. but I need to achieve same goal for all the columns....

this will give me result that 240 rows has bad data as a TotalCHAR013

SELECT

SUM(CASE WHEN CHARINDEX (CHAR(013),BASEDESC) >0 THEN 1 ELSE 0 END) AS TotalCHAR013

FROM ...

I am trying get count from all the columns in database which has bad data. the above example is based on one column and one table. I would like to...

My query is based on one table and one column. I need to provide development team report to see which columns need to address in their application. I am having...