Unexpected behavior from like operand

Not sure if this behavior is supposed to happen, but let's say I have a String property P on nodetype N. There is a node N with property P = 'Capital0'

The following query does not find this node: (as expected)

select [P] from [N] where [N].[P] like 'capital%'

The following query however, does:

select [P] from [N] where [N].[P] like '%capital%'

Which I did not expect, so I'm thinking this might a bug.