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
Enjoy!