Converting Datatype

[Preetham16]

I would like to convert Varchar to Numeric and the following code am using in SQL but still am getting problems...

cast(Cast(a.partner as char)as numeric(10)) as Partnernr

regards..

PR

 

[Crowley16]

char(?)

--------------------
Procrastinate Now!

 

[SQLDenis]

convert(numeric(10),a.partner) as Partnernr

you sure you don't want INT instead since you didn't specify decimals?

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[Preetham16]

Hi thanks for the replies

I dont need DECEMALS...when I use INT its saying ILLEGAL EXPRESSION.

PR