[Message Deleted]

[Reethika]

[Message Deleted]

[Blue_Boy]

if you have to recognize quotation mark on SQL then use four quotations to get result as single one like this: select ''''+'single quotation mark'

---

I Love T-SQL

[Reethika]

Thanks for ur reply, I've to write in Vb. Its a mailing proj. While sending msg in a mail, IF the user uses (') then it crops error. How to overcome it

[Blue_Boy]

Have you tried doubling up any single quotes to escape them when they're in the string? stringvalue.Replace("'", "''")

---

I Love T-SQL

[VanithaVasu]

I don't have any Idea in Vb. But in C# For ex: if we want our string to diaplay like - xml version="1.0" then we have to code like -- xml version= "\" 1.0 \"". So here you will get the output as: xml version="1.0"

VanithaVasu