Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Sql Qry

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2007-03-12 : 09:20:24
prasant writes "I m facing problem while inserting '(single quote) into sql server 2000. Is there any way to insert single quote

e.g.: insert into table_name values('Father's Name')"

PurpleSun
Yak Posting Veteran

50 Posts

Posted - 2007-03-12 : 09:44:03
Replace single quote with double quote like ('Father"s Name')
Go to Top of Page
   

- Advertisement -