Hi if you want to search in your table where the name filed has a leading or trailing space you could use the following

select * from table

where patindex('% %',collumn)>0

if there is a space anywhere in the collum a result will be returned