VBA for Excel 2013: Instr produces incorrect result

[nicovanniekerk]

dim a
a="CREATE MENU [Staging].[OAs] AS"
?instr(a,"AS"), len(a)
29

a=lcase("CREATE MENU [Staging].[OAs] AS")
?instr(a,"as")
25

a=ucase("CREATE MENU [Staging].[OAs] AS")
?instr(a,"AS")
25

Why the difference when using ucase or lcase, missing the correct position by exactly 4 characters? Anyone?

Nico

[nicovanniekerk]

Sorry, the third line should not have ", len(a)"
It reported 30, anyway.

[vbfbryce]

Because ucase converts the [OAs] to [OAS], and the "AS" in the brackets starts in position 25.

[nicovanniekerk]

Because ucase converts the [OAs] to [OAS], and the "AS" in the brackets starts in position 25.

Funny how one's mind is made up beforehand what to expect. Especially when it's late and one is tired.

Thanks.