It certainly can. I worked for a (very) small consulting firm. We basically wouldn't entertain hiring anyone with a non-compete that was remotely applicable. Just too much potential risk/cost. Doubly so if they worked for a client or a competitor. (Quite common.)