SQL PHP HTML ASP JavaScript articles and free scripts to download
SQL String Functions

ucase & lcase string functions

We can change a lower case data ( string ) in out mysql table to upper case by using ucase function. Same way we can change upper case characters to lower case by using lcase function. Here is the syntax

select ucase('this is a string')

The output will be THIS IS A STRING
Same way we can use lcase string function to change upper case characters to lower case by using lcase function

select lcase('This is a String')

The output is this is a string

In our newsletter subscribers table we can convert or display all the emails in lower case letters. While subscribing visitors may enter their email address in Upper case letters. We can use lcase to change all email address to lower case characters .

select lcase(email) from subscribe

The above command will display only. We can use update command to change the records. Same way we can change to upper case also.

select ucase(email) from subscribe

Be the first to post comment on this article :


Google+

Post Comment This is for short comments only. Use the forum for more discussions.
Name
Email( not to be displayed)Privacy Policy
1+2=This is to prevent automatic submission by spammers. Please enter the result of the sum as asked




HTML . MySQL. PHP. JavaScript. ASP. Photoshop. Articles. FORUM Contact us

©2000-2014 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer