case insensitive InStr

[jdwyer05]

I understand that InStr is case senstive. Is there an alternate function that is case insensitive?

[albertw]

I understand that InStr is case senstive. Is there an alternate function that is case insensitive?

hi

no there is not, but you may shortcut this by using UCase() or LCase()

[jdwyer05]

Thanks, lcase worked

[Killer42]

Thanks, lcase worked

Actually, according to the documentation (VB6) you can use Instr and simply tell it not to be case-sensitive. This might be more efficient than converting the text to upper- or lower-case all the time.

InStr([start, ]string1, string2[, compare])

vbBinaryCompare 0 Performs a binary comparison.
vbTextCompare 1 Performs a textual comparison
...
In English-U.S., binary comparisons are case sensitive; text comparisons are not.

[albertw]

Actually, according to the documentation (VB6) you can use Instr and simply tell it not to be case-sensitive. This might be more efficient than converting the text to upper- or lower-case all the time.

learned again something today