| Subject | Cast numeric(4,2) as Varchar(20) returns null string |
|---|---|
| Author | robertosmith8 |
| Post date | 2008-06-07T13:13:32Z |
Hi,
if X is defined as follows:
declare variable X numeric(4,2);
or
declare variable X numeric(9,4);
Why is it that CAST(X AS VARCHAR(20)) returns a NULL string? (for
instance X = 5.5, the CAST function returns a NULL string)
Thanks.
roberto
if X is defined as follows:
declare variable X numeric(4,2);
or
declare variable X numeric(9,4);
Why is it that CAST(X AS VARCHAR(20)) returns a NULL string? (for
instance X = 5.5, the CAST function returns a NULL string)
Thanks.
roberto