Hi,

Hope this is what you are expecting :

declare @sql varchar(1000)

select @sql = 'case '

select @SQl = @sql + ' when value ' + compareoperator + ' ' +

case

when...

Thanks for responding.

I have only one sheet in my excel file Sheet1 but in import and export wizard it displays 2 Sheets - Sheet1 and Sheet1$.