Hi,

We have an another way if you can use DTS.

Through ActiveXScript we can use FSO and find out the latest file from the folder and assign the valid excel...

Hi,

This is really a perfect example for "Case" statement.

You can try this query....

**************

create table testfeb

(

FullName varchar(5), AddressHome varchar(10), AddressPO varchar(10), CustPhone char(10)

)

Insert into testfeb(FullName,

AddressHome,

AddressPO,

CustPhone)Values('Abc','','Address1',2323)

Insert into testfeb(FullName,

AddressHome,

AddressPO,

CustPhone)Values('def','Address2',null,2323)

Insert into testfeb(FullName,

AddressHome,

AddressPO,

CustPhone)Values('jkl','Addres','Address6',2324)

Select *...