How to use Cast

[chinni0719]

Can you plz help me in this

declare @amount NUMERIC(10,0)
set @amount =(select income from incometable )

select
case

when (@amount IN ('NA','na','n/a','N/A'))
then 'ACF'
when (@amount = 0)
then 'PT'
else 'NA'

end

I declare @mount as numeric but i should send characters ,how to cast

Thanks

[ck9663]

Can you plz help me in this

declare @amount NUMERIC(10,0)
set @amount =(select income from incometable )

select
case

when (@amount IN ('NA','na','n/a','N/A'))
then 'ACF'
when (@amount = 0)
then 'PT'
else 'NA'

end

I declare @mount as numeric but i should send characters ,how to cast

Thanks

First, what's the data type of your income column from your incometable? In order for you to check if the value is a string, it should be a string.

-- CK

[chinni0719]

numeric(10,0) income field

[ck9663]

Then your column will contain numeric values or NULLS (if you allow it), ONLY.

This: @amount IN ('NA','na','n/a','N/A') will never be true and will in fact throw an error.

-- CK