For me, I am always using % in LIKE statements, although there is a minor difference which is:

% means 0 or more characters in this position.

_ means 1 character only @ that position.

http://msdn.microsoft.com/en-us/library/069b0htd(v=vs.110).aspx"> http://msdn.microsoft.com/en-us/library/069b0htd(v=vs.110).aspx

hmmm, interesting.