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 |
|
gln
Starting Member
2 Posts |
 Posted - 2005-12-31 : 12:57:14
|
| Trying to change some of the rows in a table specifically one column.column type is varcharex. of datacurrent desired $345,434.0 345434.0 (stripping out of $ & commas)435.0 leave as isgeneral txt leave as ishaving trouble updating data in tabletried using temp table, but update command make it so it won't see tableex. piece of codeupdate currency_conversionset currency_varchar = cast (cast (currency_varchar as money)as varchar)select * from currency_conversionwhere substring (currency_varchar from 1 for 1) = '$' ;sql 2000trying to do from query analyzerthanksglnsk8ter@yahoo.comthanksGlenn |
|
|
cshah1
Constraint Violating Yak Guru
347 Posts |
Posted - 2005-12-31 : 13:28:02
|
| cross posthttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=59707 |
 |
|
|
|
|
|
trying to modify some column data in some rows