' Character in SQL

[J P Singh]

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?

 

[J P Singh]

Sorry I mean to say the problem is with the Select query.

 

[Per-Olof Nilsson]

Use double '. For example if a string is 'Peter's'. Then you should send
this to database: 'Peter''s'

 

[John Blessing]

Sorry I mean to say the problem is with the Select query.

http://support.microsoft.com/?id=246069

--
John Blessing

http://www.LbeHelpdesk.com - Help Desk software priced to suit all
businesses
http://www.free-helpdesk.com - Completely free help desk software !
http://www.lbetoolbox.com - Remove Duplicates from MS Outlook

 

[J P Singh]

many thanks

http://support.microsoft.com/?id=246069

--
John Blessing

http://www.LbeHelpdesk.com - Help Desk software priced to suit all
businesses
http://www.free-helpdesk.com - Completely free help desk software !
http://www.lbetoolbox.com - Remove Duplicates from MS Outlook

 

[Aaron Bertrand - MVP]

http://www.aspfaq.com/2035