thanks watatop

Hi ,

I am using MS-Access

The connection string i have written as followings

<add key="DBConnString" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\LIC\Code Base\LICIQuotation_NEW\Quotation_DB_New.mdb;Persist Security Info=False;"/>

I am getting "Keyword not supported: 'Provider'" What is cause of this. I...

Me too so much...................

We can use case statement in where clause as follows:

declare @x int

Select col1,col2

from table1

where col1 = case when @x = 1 then 1000

...

Thanks Jack for reply

yes, it is possible once we get value that column then we can found actual value of that column.

Regards.

Yours

Thanks a lot my problem solved from your given sugestion

Regards,

Tatoba