I am trying to update a SQL Server 2000 database with the value from a textbox on an ASP page. \r\n \r\nUsing Access I\'ve always just done (Ken\'s Function): \r\n"UPDATE table1 SET [txt]=\'" & "Ken" & Chr(39) & "s Function" & "\'" \r\n \r\nHowever, with SQL Server I get the following error. \r\n \r\n"\'chr\' is not a recognized function name." \r\n \r\nI realize I need to write some sort of SQL User Defined Function, but am unsure how. \r\n \r\nCan Anyone Help?