Re: ' Character in SQL

From: Aaron Bertrand - MVP (aaron_at_TRASHaspfaq.com)
Date: 02/12/04 

Date: Thu, 12 Feb 2004 09:35:18 -0500

http://www.aspfaq.com/2035 

-- 
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"J P Singh" <noemail@asIhatespam> wrote in message
news:eQHfqnU8DHA.2480@TK2MSFTNGP10.phx.gbl...
> Hi All
>
> We have an application which uses surname and the date of birth to allow
> people to login.
>
> The SQL gives an error if the user's surname contains the character '
>
> Anybody knows a way around this?
>
>

Relevant Pages

  • Re: Find the first available integer.
    ... by being in simple recovery model). ... using a real server with a real disk system, and if you insert a reasonable ... Aaron Bertrand ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: datetime problem
    ... parameter statement. ... How many language tables do you have? ... >> Aaron Bertrand ... >> SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: back to referring page
    ... were a direct result of my fingers and brain not being synchronized or my ... "Aaron Bertrand - MVP" wrote in message ... > SQL Server MVP ... >> lack of caffeine. ...
    (microsoft.public.inetserver.asp.general)
  • Re: Trigger for tracking moddate & moduser
    ... update as many rows as were affected by the original statement. ... (SELECT primaryKey FROM Inserted) ... >> Aaron Bertrand ... >> SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Timer function
    ... Can you show the EXACT error message you received (including the 0x800xxxxx ... >> Aaron Bertrand ... >> SQL Server MVP ... >>> I am having a problem calling the Timer function. ...
    (microsoft.public.inetserver.asp.general)