Insert Into MyTable

SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;Database=C:\BlankDB.xls', Sheet1$)

GilaMonster (11/8/2008)

Null won't cause a divide by zero. Anything divided by null (or added to null or multiplied by null, ...) is...

Would null values cause this.

See if ISNULL helps.

have u tried the len function...

as in len(ltrim(rtrim(strVar))) .

Karthik, so are you gonna say that your head is a limitation...:)

looks like you have decided that it is a limitation...

so be it...

my reply has come a little late now... so I might seem out of context now.

Karthik, my only argument was there is no problem with local variables and IN clause...

u can.....

drop table #tmp

go

Create table #tmp

(

eno varchar(1),

ename varchar(25)

)

go

insert into #tmp

select '1','Karthik'

union

select '2','Keyan'

union

select '3','Mani'

Declare @eno varchar(10)

declare @STR varchar(100)

set @eno = '1'

select * from #tmp where eno in...

nah.....pretty bad with syntaxes myself...

and what is the problem with local variable and IN Clause?

I didnt get the local variable not working with IN clause....

Do you mean you want to do a ALTER TABLE ALTER COLUMN.....

Use isnull(col3,'') instead of a just col3.

I think u will have to explain a little more with some code...

Is there any reason for storing data in this manner in the table?