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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-11-12 : 13:46:59
|
| Shoba writes "Consider the following scenario:Create table #temp1 (fld1 varchar(100))Insert into #temp1 values ('100+50')Insert into #temp1 values ('200+50')Create table #temp2 (fld1 float)I want to insert into #temp2, the calculated values of fld1 from #temp1. That is, if I do a Select * from #temp2, I should get150 and 250. How do I write a query which will accomplish this?Regards,Shoba" |
|
|
|
|
|
String Evaluation