Dear Richard,

I just went through a situation which i thought might be worthwhile to share. i have a list of censored words in a table which a user must never include in an SMS message to a customer. So when an SMS is written in a textbox [actually a text area] on a web page, i loop through all the words in the table and check if any of them is part of the SMS using a recordset and the Instr function.
What i realised is that the result returned is case sensitive. For instance a censored word of Party in the table is not equal to PARTY. it took me hours to figure out why my code was not working as expected.
in Access VBA, we get away without being bothered by case sensitive characters. With ASP, NOPE.

MICAH

---

Reply from Richard Rost:

That is correct. ASP is very highly case sensitive. Thanks for sharing.