3 Popular SQL String-functions

3 Popular SQL String-functions
Photo by Toa Heftiba on Unsplash

The function UPPER-It converts a string into the UPPER case.

Syntax.

UPPER (Column_name)

The LOWER function-It converts string into lower case.

Syntax:

LOWER (Column_name)

The INITCAP function-It converts the first letter into CAPITAL.

Syntax:

INITCAP(Column_name)

The trim functions. Read examples online here.

The LTRIM. It looks for the left side of the String.

Syntax:

LTRIM(column_name,’*’);

The RTRIM. It looks for right side of the string.

Syntax:

RTRIM(column_name,’*’);

Sources

--

--

--

Sr.Software Developer - Technology @srinimf.com

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Dune-Building a Dashboard

From Python To Ruby

Cloud Computing Overview

My First Hackathon...Summed Up

Understand the Flow of a HTTP Request

Save your coworkers’ time with Google Sheets and Google Cloud Functions

Lessee Accounting for ASC 842 Requires Software. Here are the Top Features to Look for.

Lease Accounting Software Mobile Interface on an Ipad

Programming Languages to Avoid and Learn in 2022

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Srinimf

Srinimf

Sr.Software Developer - Technology @srinimf.com

More from Medium

SQL — How your CS degree only scratches the surface

Most Common Applications of SQL Window Functions

Basics Of NumPy

Loading…

cxplot: the ggplot of JavaScript