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 |
engcanada
Starting Member
39 Posts |
Posted - 2008-06-10 : 12:01:48
|
Hi,Any idea how I can use the following to replace a double quoatation mark:string_text= Replace(string_text, """, "")Thank |
|
engcanada
Starting Member
39 Posts |
Posted - 2008-06-10 : 12:54:50
|
I figured it out, any of the follwoing will work: vblintroduction =Replace(vblintroduction, Chrw(&H201C), "“") vblintroduction =Replace(vblintroduction, Chrw(&H201D), "”") vblintroduction =Replace(vblintroduction, chrw(&H22), "“") vblintroduction =Replace(vblintroduction, """", "“") vblintroduction =Replace(vblintroduction, chr(34), "“") |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-10 : 12:56:08
|
You'll have better luck next time if you post in the correct forum. The script library forum is for working scripts and not for asking questions. I will move your post as a result.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
|
|
|
|