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 |
|
Sajid_khan07
Starting Member
1 Post |
 Posted - 2007-06-26 : 06:48:51
|
| I am receiving data in text format in one column from a third party. The text has 2 numeric values which i want to separate and put in 2 differnt columns, how do i do it?For example: Course 146 degrees Speed 11 knotsI need 146 and 11 to go into two columns..Pls suggest.Thx |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
How to convert text column to 2 columns (float)