Converting text string of numbers to numeric

[crystalfun]

I have a text string of 8 numbers that I bring into Excel but I want them to come over as true numbers to then run other command from.

Whats the sql command to convert text numbers to real numbers.

 

[Andel]

You can use the CONVERT function.

SELECT convert(INT, MyNumber) FROM Tablename

That is if you're converting to an integer. You can use other like Decimal, etc...

Andel
andel@barroga.net

http://andyb.8m.com