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)