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-04-05 : 17:25:45
|
Averno writes "I need to replace all the " and ' on a table, but, the provider can't run the "REPLACE" statement because he runs a 6.5 version (mine is a 7.0). Do someone knows a way to obtain the same goal with a different script?
This is the script i wrote (in T-SQL 7.0) and that can't be used on my provider SRV.
UPDATE tablename
SET fieldname = REPLACE(fieldname,'"','')
(Graz's note: This script will look wrong because I'm storing these quotes in a SQL Server)
Thank you in advance.
Bye." |
|
|
|
|
|
Replacing WITHOUT replace