You can check for '.' in the string
CASE CHARINDEX('.', answer) > 0 THEN
>I have a table having a field called 'answer' is Varchar. We need change all values to Int.
>
>678 TO 678 (INT to INT don't change)
>Y TO 1
>N TO 0
>5.56 TO 556 (Real to INT by time 100, this is price)
>
>I used
>
>questionresponse=
>case
> when isnumeric(answer)=1 then answer -- need change
> when isnumeric(answer)=0 and answer= 'Y' then '1'
> when isnumeric(answer)=0 and answer= 'N' then '0'
> when isnumeric(answer)=0 and answer= '-' then '0'
>end
>
>The only thing is how can we figure out which one is real. Do we have the function to identify Int and Real like isreal?
>
>
--sb--