Handle apostrophe

[Palmyra]

Is there a SQL function (instring maybe) to search and replace single quotes (or apostrophes) with double quotes in a string? So that we can insert strings with names like O'Brien, etc.

Thanks.

 

[markros]

No, as far as I know. However, it should not be a problem if you're passing O'Brian as a parameter and not as a literal string (concatenation).

PluralSight Learning Library

 

[bborissov]

Not built-in
But you could write your own.
BTW If you pass your strings as parameters from your FrontEnd the ODBC driver or Provider will handle then easily.

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[simian336]

I simply remove them...

--Remove Single quotes from the comment
Update [RepliconTemp].[dbo].[tdctim_TDC]
set tmcomment = replace(tmcomment,char(39),'')
where CHARINDEX(char(39), TMCOMMENT)>0

Simi

 

[bborissov]

And O'Brien stands OBrien?
Hmmm, not very polite

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[markros]

I agree - and also if you save the text, like

I'm a person

it will become

Im a person



PluralSight Learning Library

 

[deejayAr]

if I understand your question clearly you might need this


INSERT Table1 (mycolumn)
VALUES ('O''Brien')