String Functions

Question 1

Returns the ASCII character based on the number code

Answer 1

CHAR

Question 2

Returns the location of a substring in a string

Answer 2

CHARINDEX

Question 3

Concatenates two or more strings together

Answer 3

CONCAT

Question 4

Concatenates two or more strings together, and separates the concatenated string values with the specified delimiter

Answer 4

CONCAT WS

Question 5

Returns the length of an expression (in bytes)

Answer 5

DATALENGTH

Question 6

Compares two SOUNDEX values, and returns an integer value

Answer 6

DIFFERENCE

Question 7

Extracts a substring from a string (starting from left)

Answer 7

LEFT

Question 8

Returns the length of the specified string

Answer 8

LEN

Question 9

Converts a string to lower-case

Answer 9

LOWER

Question 10

Removes leading spaces from a string

Answer 10

LTRIM

Question 11

Returns the Unicode character based on the number code

Answer 11

NCHAR

Question 12

Returns the location of a pattern in a string

Answer 12

PATINDEX

Question 13

Replaces a sequence of characters in a string with another set of characters

Answer 13

REPLACE

Question 14

Repeats a string value a specified number of times

Answer 14

REPLICATE

Question 15

Reverses a string and returns the result

Answer 15

REVERSE

Question 16

Extracts a substring from a string (starting from right)

Answer 16

RIGHT

Question 17

Removes trailing spaces from a string

Answer 17

RTRIM

Question 18

Returns a string with a specified number of spaces

Answer 18

SPACE

Question 19

Returns a string representation of a number

Answer 19

STR

Question 20

Escapes special characters in texts and returns text with escaped characters

Answer 20

STRING_ESCAPE

Question 21

Escapes special characters in texts and returns text with escaped characters

Answer 21

STRING_SPLIT

Question 22

Deletes a sequence of characters from a string and then inserts another sequence of characters into the string, starting at a specified position

Answer 22

STUFF

Question 23

Extracts a substring from a string

Answer 23

SUBSTRING

Question 24

Returns the string provided as a first argument after some characters specified in the second argument are translated into a destination set of characters

Answer 24

TRANSLATE

Question 25

Removes the space character or other specified characters from the start or end of a string

Answer 25

TRIM

Question 26

Converts a string to upper-case

Answer 26

UPPER