Did you ever resolve this problem? The response re: http://www.codeproject.com/Articles/33941/SQL-LIKE-Operator
was not the correct answer for this problem.
I have found that adding zzzz to the end range works. Is there anything more elegant than that?