substring, patindex?

[JHausmann]

select name from table where name like "Bond *"

-or-

select name from table where name like "Bond %"