Hi Abhijit,

Please try this,

Select CAST(41981 as datetime)

Output

2014-12-10 00:00:00

Thanks,

Srikanth s

Hi Nidhi,

Try this,

Declare @k char(10)

Declare @l as Char(10)

Set @k ='-88'

set @L = '88'

Select IIF( ISNUMERIC(@k) = 1,

Case

When Cast(@k as integer) > 0 then 'Positive'

When Cast(@k...