yes, we make in-house employees sign one. rarely use contractors, but if we do, we make them sign one too.
its more a threat than anything, but have had to seek legal action against someone in the past. they easily folded, so guess it holds up more than I thought.
I actually got sued under a non-compete, but was to general and tossed out of court
