Replacing “ in a string

[shashi]

I am using SQL server 2000 as my data base and the col. which is holding this
data is of type “text� data type. When I am generating an HTML page by
getting data from data base, it is displaying a special character. when I am
trying to replace this “ character with " , the replace function of dot net
is unable to replace it.

[Anand]

Can you just copy the lines you are using to replace the character?
Anand

[Blue Streak]

Try something like:

Private Function ScanInput(InputStr as String) as String
'This function will scan the input string InputStr for special
characters (e.g. Chr(39))
'and replace them with the SQL escape-sequence to allow MSSQL
Server to handle the input properly.
If (InputStr.Length = 0) Then
Return Chr(160)
Else
ScanInput = Replace(InputStr, Chr(39), Chr(39) &
Chr(39))
End If
End Function

I think ' = Chr(39), " = Chr(34) and   = Chr(160). Run it when
you are about to save a string of text to the database.

[Anand]

But this way you will have to scan for all the special characters
If you have html string ready and works fine on the browsers and the
same you are storing in the Text datatype, I think it will return you
exact string.
Anand