Allvendors

Changing the case of text in SQL is a common task when comparing strings or validating data. Learn how to do it with the UPPER, LOWER, and INITCAP functions in this article.

SQL NVL, ISNULL, and Other Logical Function Guide, FAQ, and Examples

Jan 1, 2018 · 14 min read · sql-functions ·

Share on:

There are several functions in SQL, such as NVL and ISNULL, that perform some kind of logic on the values that are provided. Learn what they all do and see some examples in this article.

SQL LENGTH/LEN Function Guide, FAQ, and Examples

Dec 24, 2017 · 6 min read · sql-functions ·

Share on:

In this article, we’ll look at the LENGTH function and its variants, and the VSIZE function, explain how they work, and see some examples.

SQL CHR, CHAR, ASCII, NCHR, NCHAR, and ASCIISTR Function Guide, FAQ, and Example

Dec 23, 2017 · 6 min read · sql-functions ·

Share on:

The SQL CHR, CHAR, ASCII, NCHR, NCHAR, and ASCIISTR functions are useful when translating between text characters and their ASCII codes. Learn all about these functions in this article.

SQL GREATEST and LEAST Function Guide, FAQ, & Examples

Dec 21, 2017 · 6 min read · sql-functions ·

Share on:

The SQL GREATEST function and LEAST function are quite useful, but not very well understood. Let’s take a look at these functions and see some examples in this article.

SQL LEAD and LAG Function Guide, FAQ, and Examples

Dec 6, 2017 · 10 min read · sql-functions ·

Share on:

The SQL LEAD function and SQL LAG function can be very useful for finding data in your result set and simplifying your queries. Learn all about them in this article.