In this SQL Server tutorial, I will show you how to use the CHAR function in SQL Server to get the character based on the provided integer value. You will learn about the syntax of the CHAR() function, and then find the character based on the provided code or integer value. Finally, you will understand … Read more
In this SQL Server tutorial, you will learn how to use the RIGHT function in SQL Server to extract the rightmost character from the given string value. You will understand the process of extracting the characters from the right side of the literal string. Then from the string value within the table column and from … Read more
In this SQL Server tutorial, you will learn about SQL Server format number with commas without decimal places. You will use the FORMAT() function to format the number with commas and without decimal places. Then use the LEFT() and LEN() functions together for the same purpose. SQL Server Format Number with Commas without Decimal Places … Read more
In this SQL Server tutorial, I will explain to you how to format number with thousand separator in SQL Server. You will understand use of the functions such as FORMAT(), CONVERT(), and CAST() to format numbers with thousand separators. Format Number with Thousands Separator in SQL Server While querying the information from the database, how … Read more
In this SQL Server tutorial, you will learn about LEFT Function in SQL Server. You will use this function to extract the leftmost character from the value. First, you will understand how to use the LEFT() function with literal string, then use the LEFT() function with table column. Finally, with the GROUP BY clause. LEFT … Read more
In this SQL Server tutorial, I will show how to use the CONVERT function in SQL Server. Where you will see how to use the CONVERT() function to convert the data type of the value to another data type in an explicit way. Also, you will learn how to apply the CONVERT() function on the … Read more
In this SQL Server tutorial, you will learn about the CAST function in SQL Server, where you will understand how to cast or transform the datatype of the value to another datatype. Finally, you will learn how to implement the CAST() function on the column of the table, also how to concatenate the CAST() function … Read more
In this SQL Server tutorial, you will learn how to format numbers to 2 decimal places in SQL Server. You will use the different functions in SQL Server to format the number with 2 decimal places. Also, you will be introduced to the syntax of each function that you are going to use in this … Read more
In this SQL Server tutorial, you will learn about format numbers with leading zeros in SQL Server. First, you will be introduced to the concept of leading zero, and then how it is beneficial in several ways. After that, you will learn how to use the FORMAT() function to format the number with leading zeros. … Read more
In this SQL Server tutorial, you will learn how to format number with commas in SQL Server. Where you will understand how to use FORMAT() function to format the number. Also, you will use the different format specifier with the FORMAT() function to format the value with commas. Format Number with Commas in SQL Server … Read more