Very Computer

by **Rober** » Sat, 17 May 2003 21:14:07

I need to insert text into a SQL Server Database and quite
often a single quote will be encountered such as
O'Reilly. The insert fails at this point. I was told to
use an escape sequence to overcome this but I am not
familiar with this process. Can anyone help???

Thanks,

Robert

by **Keith Kratochvi** » Sat, 17 May 2003 21:19:36

Double up on the quote that you want to 'escape'

PRINT 'O''Reilly'

--
Keith, SQL Server MVP

> I need to insert text into a SQL Server Database and quite
> often a single quote will be encountered such as
> O'Reilly. The insert fails at this point. I was told to
> use an escape sequence to overcome this but I am not
> familiar with this process. Can anyone help???

> Thanks,

> Robert

Very Computer

escape sequence for varchar

escape sequence for varchar

escape sequence for varchar