The SQL LOWER function converts the input character data to a lower case. Description The LOWER function takes character expression as an

Read More
SQL LOWER Function (Transact SQL)

The SQL UPPER function converts the input character expression to an upper case and returns it. Description The UPPER function reads the

Read More
SQL UPPER Function (Transact SQL)

The SQL PATINDEX function searches an input expression for a given pattern. It returns the starting index of the first occurrence of

Read More
SQL PATINDEX Function (Transact SQL)

The SQL RTRIM function trims all the trailing spaces from the right side of the input character expression. Description The RTRIM function

Read More
SQL RTRIM Function (Transact SQL)

The SQL LTRIM function removes the leading blank spaces from the input character expression. Description The LTRIM function returns a character expression

Read More
SQL LTRIM Function (Transact SQL)

The SQL CHARINDEX function returns the starting position of a character expression in another character expression. Description The CHARINDEX function helps with

Read More
SQL CHARINDEX Function (Transact SQL)

SQL REPLACE function evaluates an input string for a specified substring pattern and replaces these substrings with another specified string value. Use

Read More
SQL REPLACE Function (Transact SQL)

Description The SQL SUBSTRING function extracts a part of input expression or a ‘substring’ and returns it. The starting position and the

Read More
SQL SUBSTRING Function (Transact SQL)

Description The SQL STUFF function deletes a specified number of characters from a character expression and replaces them with another substring. In

Read More
SQL STUFF Function (Transact SQL)

Description The SQL RIGHT function returns the specified number of rightmost characters of a given character expression. The rightmost characters are those

Read More
SQL RIGHT Function (Transact SQL)

Description The SQL LEFT() function returns the specified number of characters starting from the left side of a given character expression. LEFT

Read More
SQL LEFT Function (Transact SQL)

The SQL LEN function returns the number of characters within a string.  Keep in mind the count of characters returned does not

Read More
SQL LEN (Transact SQL)