Currently we translate foobar.StartsWith(foo) into: (foobar like foo +'%' and left(foobar, len(foo)) = foo) or foo = '' -- last term is removed if foo is non-null constant however @rmacfadyen point...