you could do a charindex check for a blank space and make sure the number returned is greater than 0. Make sure you trim your input though incase you have white space.

I think you could also use like '% %' but that should probably be avoided for performance reasons

i would personally use charindex but would like to see what others say