In some cases, people prefer their database records to contain all UPPER or all lower case letters. For example, when someone submits a contact form to you, you could simply use UCASE and LCASE.
<% DIM strLastName strLastName = "Smith" Response.Write "Upper Case: " & UCASE(strLastName) & "<br>" Response.Write "Lower Case: " & LCASE(strLastName) %>
No matter how the user enters their Last Name, here is how it will display:
Upper Case: JAMESTOWN
Lower Case: jamestown