Gosh... I am sorry i am not ignoring... i trying to find some simpler way if any else i have your suggestion in store. Looking for something easier as i...

Then how about Left(Capacity,1) = '-'

I was trying to get a solution and came up with this -

select * from table WHERE ISNUMERIC(LTRIM(RTRIM(Capacity))) = 1 AND Capacity < '0'

It is working fine now...

Yes. Thanks. It does work this way.. but dont we have any other way to check for < 0 in sql?

thanks Gila .... 🙂 my lead asked me to use table variable instead so it was confusing...

well i have used temp tables now

Thanks.. I also used the temp table instead. BUt my lead somehow asked me to use table variable 🙁

So now ill be using temp tables only

Thanks.. I am done with this 🙂 thanks for taking out time...

Can you please tell me if we can use table variable in join condition in dynamic query or...

Please if anyone can help me optimizing this where clause where i need not use these multiple isnull checks

Thanks a lot guys........

real helpful

Hey..

Thanks.

removing the index helped by bringing down the time to 6 seconds.

Can you please help me with why it might have been used in first place. (possible reason...