select left( yourfield, charindex(' ', yourfield)-1) from yourtable
It means the field doesn't have a space in it, that's what it's looking for.
Jared_S
Working off Angel's suggestion...
select left( yourfield, patindex('%[^0-9]%', yourfield)) from yourtable
Jared_S
If this field is an nvarchar(255), then it's either bigger than it needs to be, or you're storing more than one value in the field.
If it's the latter, then you'll need a user defined function to strip the characters out of the entire string. dkrollCTN posted a link to handle that scenario.