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?