Well the second one will use a scan as its not SARG-able due to it being '%...%'

What is the output with statistics time switched on and also what do the executions plans show.