On Jul 2, 2:34=A0pm, Erland Sommarskog <esq...@[EMAIL PROTECTED]
> wrote:
> t8ntboy (t8nt...@[EMAIL PROTECTED]
) writes:
> > The following character keeps appending itself to data inserted
> > through a web form. =A0What is it from (how is it generated) and how
ca=
n
> > it be removed? =A0 =A0Here it is: =A0=C2
>
> There is not enough information in your post to even make it guess where
> it comes from. In any case, I would suspect that this is related to the
> web software or the client API and not SQL Server.
>
> You can remove it with:
>
> =A0 UPDATE tbl
> =A0 SET =A0 =A0col =3D substring(col, 1, len(col) - 1)
> =A0 WHERE =A0col like '%=C2'
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@[EMAIL PROTECTED]
>
> Books Online for SQL Server 2005
athttp://www.microsoft.com/technet/prodt=
echnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000
athttp://www.microsoft.com/sql/prodinfo/=
previousversions/books.mspx
The way to see if SQL Server itself is generating this( which is
highly doubted under any /sp/build/QFE ) is to install client tool
and use query analyzer and update a row using another client machine
or from the application server.
If char is not present, then the application's parser or delimitor
functionality or the IOstream needs to be examined.
|
