substring, patindex?

[Lafor]

Hi!

I have name fields in a table
like
Bond James
Want to wipe out James

select name from table where ???????

Any help is appreciated...

[JHausmann]

select name from table where name like "Bond *"

-or-

select name from table where name like "Bond %"

[Lafor]

The problem was I had to do it on all the names on the table

But the solution I came up with
was

select name = substring(ltrim(name),1,PATINDEX("% %",ltrim(name)))
where patindex("% %",name) > 0

removes text following a space from the name
while ignoring leading spaces (in fact it removes them as well)

Thanks again