Tuesday, 29 November 2011

UPPER AND LOWER CASE DATA

For consistency purposes, it is often a good idea to insure that all of your database records contain all upper or lower case letters. If you have an application that matches records between multiple tables or verifies data like with a password security application, having upper and lower case data can cause havic for you. So to keep this from becoming a problem, you can use the UCASE and LCASE.

<% DIM strPassword strPassword = "Jamestown" Response.Write "Upper Case: " & UCASE(strPassword) & "
"
Response.Write "Lower Case: " & LCASE(strPassword)
%>

Here is how it will display:
Upper Case: JAMESTOWN
Lower Case: jamestown

Enjoy!
http://www.aspwebpro.com/aspscripts/records/ulcase.asp

No comments:

Post a Comment