O'Reilly logo

Netezza SQL by Mike Larkins, Tom Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 11 - Substrings and Positioning Functions

"The afternoon knows what the morning never suspected.“

Swedish Proverb

The LOWER Function

The syntax for using LOWER:

SELECT   LOWER(<column-name>)

FROM   <table-name>

WHERE LOWER(<column-name>) = { '<character-literal>' | <column-name> } ;

image

It has been discussed earlier that there is no need for concern regarding the use of lower or UPPER case characters when coding the SQL. As a matter of fact, the different case letters can be mixed in a single statement. The NPS RDBMS is case sensitive, regarding the data. As seen earlier this means that it knows the difference between a lower case letter ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required