checking space or any charactor in value in any column

select name from emp where charindex(' ',name)>0