How do I convert text to integer?

[john0532]

I'm new to Transact-SQL. I've got a number in a varchar field that I need to get the numeric value of. How do I go about this?

Thanks

 

[SQLBill]

It's always best to give an example of some data, but here goes:


SELECT CONVERT(int, datafield)

Replace datafield with whatever your varchar datafield name is. This will ONLY work if there are numbers and only numbers in the field.

-SQLBill

 

[john0532]

Great. Now how do I put the numerical value into a variable of type int?

 

[SQLBill]

Just like I showed you.

Let's say this is your VARCHAR column with numeric data:

COL
1
534652
7381704
721
793948
9866

What I gave you will take that data and return it as an integer.

If that's NOT what you wanted, please explain it futher and provide sample data and what you want done with it.

-SQLBill

 

[john0532]

Thanks again. Your statement "returns it as an integer" answered my question