Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
javabuddy
Starting Member
4 Posts |
 Posted - 2014-12-06 : 08:03:16
|
| Hello,I have a column which keeps numeric data in form of String, but I want to convert it to number e.g. from "1001" to 1001, Which function I can use to do it?http://javarevisited.blogspot.com/ |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-12-06 : 10:36:29
|
| CAST(string as number) |
 |
|
|
javabuddy
Starting Member
4 Posts |
Posted - 2014-12-07 : 03:50:07
|
| Thank gbritton.http://javarevisited.blogspot.com/ |
|
|
|
|
|
|
How to convert String to number