Our Training Programs

All contents are copyright of their authors.

Convert expression into LOWER / UPPER case in sql

Convert expression into LOWER / UPPER case in sql

Hiren Soni

Reactions

Convert expression into LOWER / UPPER case in sql:

You can make use of lower() function to convert expression in lower case

SELECT LOWER(FIRST_NAME_COLUMNNAME)

FROM TABLE

You can make use of upper() function to convert expression in lower case

SELECT UPPER(FIRST_NAME_COLUMNNAME)

FROM TABLE

1 Comment

Join the conversation! Your thoughts help the community grow.

It is the same account you read, post and publish with — and you will come straight back to this page.

Prashanth Kumar Thadaka5y ago
You can make use of upper() function to convert expression in upper case, not in lower case, please update the mistake.