Test Your Microsoft SQL Server STRING Functions Knowledge with This Quiz

Progress

True / False

The STRING_AGG function concatenates values from multiple rows into a single string.

True False

STRING_AGG is an aggregate function that concatenates values from multiple rows into a single string, with a specified separator.

True / False

The LEFT function extracts a specified number of characters from the start of a string.

True False

The LEFT function extracts the specified number of characters from the start (left side) of a given string.

True / False

The REVERSE function is used to convert all characters in a string to uppercase.

True False

The REVERSE function returns the reverse of the specified string; it does not change character case.

True / False

The CHARINDEX function returns the starting position of a substring within a string.

True False

The CHARINDEX function returns the starting position of a substring within a string, with 1 as the first position.

True / False

The REPLACE function is used to remove all occurrences of a substring from a string.

True False

The REPLACE function replaces all occurrences of a specified substring with another substring in a given string.

True / False

The LEN function returns the number of characters in a string, excluding trailing spaces.

SQL Code

SELECT LEN(' SQL Server ');

True False

The LEN function returns the number of characters in a string, excluding trailing spaces but including leading spaces.

True / False

The RTRIM function removes trailing spaces from a string.

SQL Code

SELECT RTRIM(' SQL Server ');

True False

The RTRIM function removes trailing spaces from a given string.

True / False

The CONCAT function can combine multiple strings into a single string.

SQL Code

SELECT CONCAT('SQL', ' ', 'Server');

True False

The CONCAT function combines multiple strings into a single string, without requiring a separator.

True / False

The FORMAT function can be used to format date and time values as strings.

SQL Code

SELECT FORMAT(GETDATE(), 'yyyy-MM-dd');

True False

The FORMAT function formats date and time values (as well as numeric values) as strings according to a specified format.

Q10

True / False

The SUBSTRING function extracts a substring from a string starting at a specified position.

SQL Code

SELECT SUBSTRING('SQL Server', 1, 3);

True False

The SUBSTRING function extracts a substring from a string, starting at a specified position for a specified length.

Q11

True / False

The LOWER function converts all characters in a string to lowercase.

SQL Code

SELECT LOWER('SQL SERVER');

True False

The LOWER function converts all characters in a string to lowercase.

Q12

True / False

The PATINDEX function returns the starting position of a pattern in a string, or zero if the pattern is not found.

SQL Code

SELECT PATINDEX('%Server%', 'SQL Server');

True False

The PATINDEX function returns the starting position of a pattern in a string, or zero if the pattern is not found.

Q13

True / False

The QUOTENAME function adds square brackets or other delimiters to a string.

SQL Code

SELECT QUOTENAME('SQL Server');

True False

The QUOTENAME function adds square brackets or other delimiters to a string, making it suitable for use as an object name.

Q14

True / False

The TRIM function removes both leading and trailing spaces from a string.

SQL Code

SELECT TRIM(' SQL Server ');

True False

The TRIM function removes both leading and trailing spaces from a string.

Q15

True / False

The STUFF function deletes a specified length of characters in a string and inserts another set of characters at a specified starting position.

SQL Code

SELECT STUFF('SQL Server', 5, 6, 'Database');

True False

The STUFF function deletes a specified length of characters in a string and inserts another set of characters at a specified starting position.

Q16

Single Choice

What does the LEN function return when applied to ' SQL Server '?

SQL Code

SELECT LEN(' SQL Server ');

9 11 1213

The LEN function returns the number of characters in a string, excluding trailing spaces. In this case, it returns 11.

Q17

Single Choice

Which function would you use to replace all occurrences of 'Server' with 'Database' in a string?

SQL Code

SELECT REPLACE('SQL Server is great', 'Server', 'Database');

REPLACE STUFF TRANSLATESUBSTRING

The REPLACE function is used to replace all occurrences of a specified substring with another substring.

Q18

Single Choice

How would you extract the first three characters of 'SQL Server'?

SQL Code

SELECT LEFT('SQL Server', 3);

LEFT RIGHT SUBSTRINGCHARINDEX

The LEFT function extracts the specified number of characters from the start of a given string.

Q19

Single Choice

Which function can be used to concatenate 'SQL' and 'Server' with a space in between?

SQL Code

SELECT CONCAT('SQL', ' ', 'Server');

CONCAT STRING_AGG FORMATTRIM

The CONCAT function combines multiple strings into a single string without requiring a separator.

Q20

Single Choice

What does the RTRIM function do to the string ' SQL Server '?

SQL Code

SELECT RTRIM(' SQL Server ');

Removes leading spaces Removes trailing spaces Removes both leading and trailing spacesReplaces spaces with hyphens

The RTRIM function removes trailing spaces from a given string.

Q21

Single Choice

Which function would you use to find the position of the substring 'Server' in 'SQL Server'?

SQL Code

SELECT CHARINDEX('Server', 'SQL Server');

CHARINDEX PATINDEX SUBSTRINGINSTR

The CHARINDEX function returns the starting position of a substring within a string, with 1 as the first position.

Q22

Single Choice

Which function reverses the string 'SQL Server'?

SQL Code

SELECT REVERSE('SQL Server');

REVERSE CONCAT STUFFRTRIM

The REVERSE function returns the reverse of the specified string.

Q23

Single Choice

How can you convert all characters in 'SQL Server' to uppercase?

SQL Code

SELECT UPPER('SQL Server');

UPPER LOWER FORMATREPLACE

The UPPER function converts all characters in a string to uppercase.

Q24

Single Choice

What does the LTRIM function do to the string ' SQL Server '?

SQL Code

SELECT LTRIM(' SQL Server ');

Removes leading spaces Removes trailing spaces Removes both leading and trailing spacesReplaces spaces with hyphens

The LTRIM function removes leading spaces from a given string.

Q25

Single Choice

Which function can format the current date as 'YYYY-MM-DD'?

SQL Code

SELECT FORMAT(GETDATE(), 'yyyy-MM-dd');

FORMAT CONCAT LTRIMRTRIM

The FORMAT function formats date and time values (as well as numeric values) as strings according to a specified format.

Q26

Single Choice

What does the SUBSTRING function return for 'SQL Server', starting at position 5 for 6 characters?

SQL Code

SELECT SUBSTRING('SQL Server', 5, 6);

SQL Se Server ServerL Server

The SUBSTRING function extracts a substring from a string, starting at a specified position for a specified length. In this case, it returns 'Server'.

Q27

Single Choice

Which function removes leading and trailing spaces from a string?

SQL Code

SELECT TRIM(' SQL Server ');

TRIM RTRIM LTRIMFORMAT

The TRIM function removes both leading and trailing spaces from a string.

Q28

Single Choice

How can you find the length of 'SQL Server'?

SQL Code

SELECT LEN('SQL Server');

LEN LEFT RIGHTSUBSTRING

The LEN function returns the number of characters in a string, excluding trailing spaces.

Q29

Single Choice

Which function returns the Unicode value of the first character in a string?

SQL Code

SELECT UNICODE('SQL Server');

UNICODE CHAR ASCIICHARINDEX

The UNICODE function returns the Unicode value of the first character in a string.

Q30

Single Choice

Which function removes a specified length of characters from a string and inserts another set of characters at a specified starting position?

SQL Code

SELECT STUFF('SQL Server', 5, 6, 'Database');

STUFF REPLACE CONCATSUBSTRING

The STUFF function deletes a specified length of characters in a string and inserts another set of characters at a specified starting position.

Q31

Multiple Choice

Which functions can be used to trim leading and trailing spaces from a string?

SQL Code

SELECT LTRIM(' SQL Server ');
SELECT RTRIM(' SQL Server ');
SELECT TRIM(' SQL Server ');

LTRIM RTRIM TRIMSUBSTRING

The LTRIM function removes leading spaces, RTRIM removes trailing spaces, and TRIM removes both leading and trailing spaces from a string.

Q32

Multiple Choice

Which functions can be used to extract a substring from a string?

SQL Code

SELECT SUBSTRING('SQL Server', 1, 3);
SELECT LEFT('SQL Server', 3);
SELECT RIGHT('SQL Server', 6);

SUBSTRING LEFT RIGHTCONCAT

The SUBSTRING function extracts a substring from a string starting at a specified position. The LEFT function extracts a specified number of characters from the start of a string, and the RIGHT function extracts a specified number of characters from the end of a string.

Q33

Multiple Choice

Which functions can be used to concatenate strings?

SQL Code

SELECT CONCAT('SQL', ' ', 'Server');
SELECT STRING_AGG(column_name, ' ') FROM table_name;

CONCAT STRING_AGG FORMATREPLACE

The CONCAT function concatenates multiple strings into a single string, and STRING_AGG is an aggregate function that concatenates values from multiple rows into a single string with a specified separator.

Q34

Multiple Choice

Which functions can change the case of characters in a string?

SQL Code

SELECT UPPER('sql server');
SELECT LOWER('SQL SERVER');

UPPER LOWER CHARRTRIM

The UPPER function converts all characters in a string to uppercase, and the LOWER function converts all characters in a string to lowercase.

Q35

Multiple Choice

Which functions can return the starting position of a substring within a string?

SQL Code

SELECT CHARINDEX('Server', 'SQL Server');
SELECT PATINDEX('%Server%', 'SQL Server');

CHARINDEX PATINDEX SUBSTRINGINSTR

The CHARINDEX function returns the starting position of a substring within a string, and the PATINDEX function returns the starting position of a pattern in a string.

Q36

Multiple Choice

Which functions can be used to format date and time values as strings?

SQL Code

SELECT FORMAT(GETDATE(), 'yyyy-MM-dd');

FORMAT CONCAT RTRIMLTRIM

The FORMAT function formats date and time values (as well as numeric values) as strings according to a specified format.

Q37

Multiple Choice

Which functions can be used to find the length of a string?

SQL Code

SELECT LEN('SQL Server');

LEN DATALENGTH LEFTRIGHT

The LEN function returns the number of characters in a string, excluding trailing spaces.

Q38

Multiple Choice

Which functions can be used to remove a specified length of characters from a string and insert another set of characters?

SQL Code

SELECT STUFF('SQL Server', 5, 6, 'Database');
SELECT REPLACE('SQL Server', 'Server', 'Database');

STUFF REPLACE SUBSTRINGLEFT

The STUFF function deletes a specified length of characters in a string and inserts another set of characters at a specified starting position. The REPLACE function replaces all occurrences of a specified substring with another substring.

Q39

Multiple Choice

Which functions can be used to return the reverse of a string?

SQL Code

SELECT REVERSE('SQL Server');

REVERSE CONCAT LEFTRIGHT

The REVERSE function returns the reverse of the specified string.

Q40

Multiple Choice

Which functions can convert strings to Unicode?

SQL Code

SELECT N'Unicode String';

N'Unicode String' UNICODE CHARASCII

The N prefix before a string indicates that the string is a Unicode string.

Q41

Multiple Choice

Which functions can add delimiters to a string?

SQL Code

SELECT QUOTENAME('SQL Server');

QUOTENAME CONCAT FORMATLTRIM

The QUOTENAME function adds square brackets or other delimiters to a string, making it suitable for use as an object name.

Q42

Multiple Choice

Which functions can be used to convert characters in a string to lowercase?

SQL Code

SELECT LOWER('SQL SERVER');

LOWER UPPER RTRIMLTRIM

The LOWER function converts all characters in a string to lowercase.

Q43

Multiple Choice

Which functions can be used to find the position of a pattern in a string?

SQL Code

SELECT PATINDEX('%Server%', 'SQL Server');

PATINDEX CHARINDEX SUBSTRINGLEFT

The PATINDEX function returns the starting position of a pattern in a string.

Q44

Multiple Choice

Which functions can return the first character of a string?

SQL Code

SELECT LEFT('SQL Server', 1);

LEFT RIGHT SUBSTRINGCONCAT

The LEFT function returns the specified number of characters from the start (left side) of a given string.

Q45

Multiple Choice

Which functions can remove characters from a string?

SQL Code

SELECT STUFF('SQL Server', 5, 6, '');
SELECT REPLACE('SQL Server', 'Server', '');

STUFF REPLACE SUBSTRINGLEFT

The STUFF function deletes a specified length of characters in a string, and the REPLACE function replaces all occurrences of a specified substring with another substring (or an empty string).

Microsoft SQL Server Database Quiz Questions