String functions

Question 1

Returns the ASCII value for the specific character

Answer 1

ASCII

Question 2

Returns the length of a string (in characters)

Answer 2

CHAR LENGTH

Question 3

Returns the length of a string (in characters)

Answer 3

CHARACTER LENGTH

Question 4

Adds two or more expressions together

Answer 4

CONCAT

Question 5

Adds two or more expressions together with a separator

Answer 5

CONCAT WS

Question 6

Returns the index position of a value in a list of values

Answer 6

FIELD

Question 7

Returns the position of a string within a list of strings

Answer 7

FIND IN SET

Question 8

Formats a number to a format like “#,###,###.##”, rounded to a specified number of decimal places

Answer 8

FORMAT

Question 9

Inserts a string within a string at the specified position and for a certain number of characters

Answer 9

INSERT

Question 10

Returns the position of the first occurrence of a string in another string

Answer 10

INSTR

Question 11

Converts a string to lower-case

Answer 11

LCASE

Question 12

Extracts a number of characters from a string (starting from left)

Answer 12

LEFT

Question 13

Returns the length of a string (in bytes)

Answer 13

LENGTH

Question 14

Returns the position of the first occurrence of a substring in a string

Answer 14

LOCATE

Question 15

Converts a string to lower-case

Answer 15

LOWER

Question 16

Left-pads a string with another string, to a certain length

Answer 16

LPAD

Question 17

Removes leading spaces from a string

Answer 17

LTRIM

Question 18

Extracts a substring from a string (starting at any position)

Answer 18

MID

Question 19

Returns the position of the first occurrence of a substring in a string

Answer 19

POSITION

Question 20

Repeats a string as many times as specified

Answer 20

REPEAT

Question 21

Replaces all occurrences of a substring within a string, with a new substring

Answer 21

REPLACE

Question 22

Reverses a string and returns the result

Answer 22

REVERSE

Question 23

Extracts a number of characters from a string (starting from right)

Answer 23

RIGHT

Question 24

Right-pads a string with another string, to a certain length

Answer 24

RPAD

Question 25

Removes trailing spaces from a string

Answer 25

RTRIM

Question 26

Returns a string of the specified number of space characters

Answer 26

SPACE

Question 27

Compares two strings

Answer 27

STRCMP

Question 28

Extracts a substring from a string (starting at any position)

Answer 28

SUBSTR

Question 29

Extracts a substring from a string (starting at any position)

Answer 29

SUBSTRING

Question 30

Returns a substring of a string before a specified number of delimiter occurs

Answer 30

SUBSTRING INDEX

Question 31

Removes leading and trailing spaces from a string

Answer 31

TRIM

Question 32

Converts a string to upper-case

Answer 32

UCASE

Question 33

Converts a string to upper-case

Answer 33

UPPER