[thelist] MSSQL character weirdness

[Mark Rees]

Hello

In this table, Name holds a full name, like "Graham Barrow"

I'm trying to split it on the first space. I thought this would be easy.
However this query


SELECT
ASCII(SUBSTRING(cm.Name,6,1)),
CHARINDEX(cm.Name,char(32),1) FROM TABLE

produces the following output:

32 0
32 0
80 0
32 0
32 0

etc

So ASCII says that char(32) is present, but CHARINDEX says different. I see
the same behaviour if I use a space like so ' '

Can anyone shed any light on this?

Thanks in advance for your help


www.itsagoodprice.com - top-brand electronics for less.