Monday, March 26, 2012

Problems with some characters

Hello
Other than the following character:' are there ay other character that may
cause a problem in SQL Server specifically invisible characters?
Thank you,
Shmuel Shulman
SBS Technologies LTD (UK)I can't think of any other characters but to use ' in SQL you replace
it with '' ( two single quotes)
HTH
Barry
E.g
Declare @.String Varchar(10)
Set @.String = 'O''Connor'
Select @.String|||Hi Barry,
I found te error and it is not related tot he characters.
Cheers,
Shmuel
"Barry" <barry.oconnor@.singers.co.im> wrote in message
news:1127320271.395799.121730@.z14g2000cwz.googlegroups.com...
>I can't think of any other characters but to use ' in SQL you replace
> it with '' ( two single quotes)
> HTH
> Barry
> E.g
> Declare @.String Varchar(10)
> Set @.String = 'O''Connor'
> Select @.String
>|||What Error?sql

No comments:

Post a Comment