try this if ur field is x in table xyz which u have to check its null or blank select x from xyz where isnull(x,'')<>'' this query check both null or blank in ur x colum give only filled records

Rakesh Jha

i am feeding combo dynamically and fix the width of combo box. so, that its value where length is greater than combo's width, the text not displayed. I want the tooltip text for each value in value1 value2 value3 so, plz help. thanks in advance:rolleyes: Rakesh Jha, Web Developer

very Simple --Query without parameter create proc procedure_name as Select * from table_name --conditional query create proc procedure_name as begin Select * from table_name End Rakesh Jha

How I can Stop Error Message When any exception occurred like where divide by zero exception occurred then error message came. But I don't want to display that message and come my message. Please give any Query example to stop error message.:confused: Rakesh Jha