converting varchar to numeric

Question

Post reply

converting varchar to numeric

b.amudhavalli

SSC Journeyman

Points: 87
More actions
October 3, 2007 at 10:53 pm

#121846

query for converting varchar to numeric

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

SwePeso SSC-Dedicated Points: 39757 More actions · Answer 1

Read about "CAST & CONVERT" in Books Online.

N 56°04'39.16"
E 12°55'05.25"

Norene Malaney SSCommitted Points: 1896 More actions · Answer 2

select convert(int,VARCHAR_VALUE)

just replace VARCHAR_VALUE with the varchar value that you want to convert to an integer.

Have a good day,

Norene Malaney

Jeff Moden SSC Guru Points: 1004402 More actions · Answer 3

b.amudhavalli (10/3/2007)
query for converting varchar to numeric

OMG! :discuss:

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)