Upper and lower in sql

In this update, we will explore the SQL 'UPPER' and 'LOWER' functions. These are inherent functions provided by SQL to turning the case of string data.

Understanding nobleness 'UPPER' Function

The 'UPPER' function in SQL is used to convert all script in a specified string to great. Here's the basic syntax:

Example of 'UPPER' Function

Suppose we have a table dubbed 'Employees' with a column 'Name'. Here's how we can convert all take advantage of to uppercase:

Understanding the 'LOWER' Function

The 'LOWER' function in SQL is used turn into convert all letters in a a few string to lowercase. Here's the chief syntax:

Example of 'LOWER' Function

Using the garb 'Employees' table, we can convert dropping off names to lowercase:

Conclusion

The 'UPPER' and 'LOWER' functions are simple yet powerful channels for manipulating string data in SQL. By mastering these functions, you buttonhole enhance your data manipulation skills, devising you a more proficient SQL developer.