Hi,

I have a database with a column defined as varchar(100) called Surname. 
When I use Query Analyzer to retrieve data from the column and display as
text, I get strange text appearing for one of the records.  Thus, the field
contains "Wilson" but when I run the following:

SELECT '''' + Surname + '''', Surnname FROM tblManagers
WHERE FirstName = 'Glenn'

I get the following result:

'Wilson d  g e d   w i t h   t h e   a '                   Wilson

Where has the "d ged with the a" come from.  If I show the results in a grid
the final apostrophe is missing from the first part of the query:

'Wilson

If I run a query using ADO and show the result on a web page, the extra text
is not shown.

Any ideas what is going on here?

Glenn

[Reposted, as posts from outside msnews.microsoft.com does not seem to make
it in.]

BigMan2001 (BigMan2***@discussions.microsoft.com) writes:
Show quoteHide quoteLooks like some junk data slipped in, and there is a NUL character hiding
there. See what

   SELECT convert(varbinary(100), Surname) FROM tblManagers
   WHERE FisttName = 'Glenn'

returns.

Parse a character seperated list of items
Enterprise Mgr - alter table fails
SSMS 2005 Default DB in Solution Explorer when creating new query
Templates in Management Studio
The Data Miner: SQL Server Data Mining Newsletter (March 2006)