Is there any best solution for handling spcail Characters such as ",&'

which create problem when you are passing these in a string or database.



Umair Latif

the only problem you should have is with the single quote.  and all you 

need to do is double them up



function sqlEncode(byval value as string) as string

         sqlEncode = replace(value,"'","''")

end function









At 12:35 AM 2/24/01, you wrote:



>Is there any best solution for handling spcail Characters such as ",&'

>which create problem when you are passing these in a string or database.

>

>Umair Latif

>

>

>



Robert Chartier

Author, AspFree.com

xxx-xxx-xxxx

rchartierh@a...

http://www.aspfree.com/devlinks

http://www.aspfree.com/authors/robert

http://www.aspalliance.com/nothingmn