I've never had problems with saving commas to a char field in SQL Server. For single quotes, you need to double up each instance of the single quote in the string before saving it. You can use the replace function when building your string or adding a parameter to a stored proc, etc.<BR><BR>[pseudo code]<BR><BR>textbox value = "You're typing single quotes"<BR>ASP = replace(textbox value,"'","''")<BR><BR>The resulting string will look like "You''re typing single quotes", but will only save one of the single quotes to the dbs.
The commas are not causing a problem. You have to replace() every apostrophe with two apostrophes.<BR><BR><%replace(text_to_insert, "'", "''")%><BR><BR>Copy and paste that line of ASP code into notepad and you'll be able to read it better.
You can use the chr() function<BR><BR>it puts character into string to help prevent errors<BR>for example chr(34) is a doublequote<BR>chr(34) & "Hello" & chr(34) is "Hello"<BR><BR>you use chr() because """ & "Hello" & """ produces an error<BR><BR>just find the appropriate ANSI Character code and plug it in<BR><BR>plug this into your browser to get some charcter codes<BR><BR>http://www.jimprice.com/ascii-0-127.gif<BR>