Search creteria based on multiple columns

[Ravi Shankar43]

Suppose i have a data table with 1 lakh records.My table have 25 columns. i want to search data table based on 10 columns. I may or may not provide input for 10 columns but i have to built query. How can i built query.

[PavanPareta]

hi you can also do this type

SELECT Column_1, Column_2, Column_3, Column_4, Column_5, Column_6, Column_7, Column_8, Column_9, Column_10 FROM tblName

Try

Pavan Pareta