Description : in this post how to get result of state name in upper case or in lower case
Query Syntax for upper case text return in result
- SELECT UPPER(sta_StateName) AS State FROM StateMaster
Result :
DISTRICT OF COLUMBIA
TEXAS
NEW MEXICO
Query Syntax for lower case text return in result
- SELECT LOWER(sta_StateName) AS State FROM StateMaster
Result :
district of columbia
texas
new mexico
Screen Shot :
Query Syntax for upper case text return in result
- SELECT UPPER(sta_StateName) AS State FROM StateMaster
Result :
DISTRICT OF COLUMBIA
TEXAS
NEW MEXICO
Query Syntax for lower case text return in result
- SELECT LOWER(sta_StateName) AS State FROM StateMaster
Result :
district of columbia
texas
new mexico
Screen Shot :
No comments:
Post a Comment