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 |
|
sahu74
Posting Yak Master
100 Posts |
 Posted - 2003-02-18 : 17:34:50
|
| I want to replace an apostrophe(') with double quotes(") using a SELECT statement. Can anyone please help.The query I am using is of the format...SELECT Replace(var1, , )FROM ...PKS |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-02-18 : 17:47:51
|
| SELECT Replace(var1, '''', '"') FROM myTable |
 |
|
|
sahu74
Posting Yak Master
100 Posts |
Posted - 2003-02-18 : 18:03:33
|
Thank youquote:
SELECT Replace(var1, '''', '"') FROM myTable
|
|
|
|
sahu74
Posting Yak Master
100 Posts |
Posted - 2003-02-19 : 12:04:22
|
Thank youquote:
SELECT Replace(var1, '''', '"') FROM myTable
|
|
|
|
|
|
|
Appears simple but not within my reach