SIMPLE command to convert string to number? Not CAST or CONVERT.

Giganews Newsgroups
Subject: SIMPLE command to convert string to number? Not CAST or CONVERT.
Posted by:  dba_2…@yahoo.com
Date: 15 Aug 2006

Dear Experts,

Ok, I hate to ask such a seemingly dumb question, but I've
already spent far too much time on this.  More that I
would care to admit.

In Sql server, how do I simply change a character into a number??????

In Oracle, it is:

select to_number(20.55)
from dual

TO_NUMBER(20.55)
----------------
          20.55

And we are on with our lives.

In sql server, using the Northwinds database:

SELECT
r.regionid,
STR(r.regionid,7,2)  as  a_string,
CONVERT(numeric, STR(r.regionid,7,2))  as a_number,
cast ( STR(r.regionid) as int )  as    cast_to_number
FROM  REGION R

1      1.00    1    1
2      2.00    2    2
3      3.00    3    3
4      4.00    4    4

SELECT
r.regionid,
STR(r.regionid,7,2)  as  a_string,
CONVERT(numeric, STR(r.regionid,7,2)  )  as a_number,
cast (STR(r.regionid,7,2)  as numeric )  as    cast_to_number
FROM  REGION R

1      1.00    1    1
2      2.00    2    2
3      3.00    3    3
4      4.00    4    4

Str converts from number to string in one motion.

Isn't there a simple function in Sql Server to convert
from string to number?

What is the secret?

Thanks

Replies