The SQLite lower() function allows you to convert a string to lowercase characters.
More precisely, it returns a copy of its argument, with all ASCII characters converted to lowercase.
Continue readingTag: string functions
How SQLite Upper() Works
The SQLite upper() function allows you to convert a string to uppercase characters.
More precisely, it returns a copy of its argument, with all ASCII characters converted to uppercase.
Continue readingHow SQLite Trim() Works
The SQLite trim() function trims whitespace or other characters from both sides of a string.
The function returns a copy of the string that you provide as an argument, with either whitespace, or other characters as specified, trimmed from both sides.
Continue readingHow SQLite Rtrim() Works
In SQLite, the rtrim() function enables you to trim whitespace or other characters from the right part of a string.
It returns a copy of the string that you provide as an argument, with the right part trimmed of either whitespace, or other characters as specified.
Continue readingHow SQLite Ltrim() Works
The SQLite ltrim() function trims whitespace or other characters from the left of a string.
More precisely, it returns a copy of the string that you provide as an argument, with the left part trimmed of either whitespace, or other characters that you specify.
Continue readingLEFT() vs SUBSTRING() in SQL Server: What’s the Difference?
In SQL Server environments, two of the many string functions at our disposal are LEFT() and SUBSTRING().
These functions do a similar thing, but there are differences. This article looks at some of the main differences between these functions.
How Language Settings can Affect your FORMAT() Results in SQL Server (T-SQL Examples)
It can be easy to forget that the T-SQL FORMAT() function provides locale-aware formatting. Locale-aware means that the locale can affect the results. In other words, the exact output you get will depend on the locale.
By default, the function uses the language of the current session to determine the locale. However, this can be overridden by passing a “culture” argument to the function. Doing this allows you to provide results for a particular locale without having to change the language of the current session.
This article contains examples of how locale can affect the results when using the FORMAT() function in SQL Server.
How to Format Negative Values with Brackets in SQL Server (T-SQL)
Here’s a quick way to add brackets around negative numbers in SQL Server when using the FORMAT() function.
The goal here is that brackets are only added to negative values. No brackets are added to positive values or zeros. Also, the brackets replace any minus sign that would otherwise be displayed (in other words, no minus sign is displayed when the brackets are used).
Although formatting is often best left to the presentation layer, there may be cases that dictate a T-SQL solution in SQL Server. In such cases, hopefully this article helps.
Standard Numeric Format Strings Supported by FORMAT() in SQL Server
This article provides a reference for the standard numeric format specifiers that can be used when formatting numbers using the FORMAT() function in SQL Server. Examples included.
Some of the examples use precision specifiers (these consist of one or two digits appended to the format specifier). Precision specifiers can be a value from 0 to 99, which specifies the precision of the result. How it works depends on the format specifier being used. For some format specifiers, it will specify the total number of digits in the result, for others it will specify the number of decimal places. In other cases it will be ignored altogether.
Custom Numeric Format Strings Supported by FORMAT() in SQL Server
This article provides a reference for the custom numeric format specifiers that can be used when formatting numbers using the FORMAT() function in SQL Server. Examples included.