"Quote" headaches

[JGresko]

I have a form that has a small free form text field that needs to be used as a search field. My problem is that usesr are putting names in like James "Jim" Smith and 5'4" male (no it's not a dating service)

The single quote (') I'm handling with

Name = rsName("cssname")
Dim found, char, txt
char = "'"
txt = Name
Call findChar(char, txt)     
If found Then
	Name = ReplaceTest(Name, "'", "''")    
End If

How can I check for a double quote(&quot to catch it before it blows up my SQL search string?

 

[JGresko]

Whoops... I meant to post this to the regular ASP forum (not .NET)

 

[ronaldr]

Can't you just escape it using \" instead of just " ?

 

[netangel]

U can also try using the chr() function with the ascii value of the ". NetAngel