String FUNCTIONS

Question 1

ASCII

Answer 1

Returns the ASCII value for the specific character

Question 2

CHAR

Answer 2

Returns the character based on the ASCII code

Question 3

CHARINDEX

Answer 3

Returns the position of a sub string in a string

Question 4

CONCAT

Answer 4

Adds two or more strings together

Question 5

Concat with +

Answer 5

Adds two or more strings together

Question 6

CONCAT_WS

Answer 6

Adds two or more strings together with a separator

Question 7

DATALENGTH

Answer 7

Returns the number of bytes used to represent an expression

Question 8

DIFFERENCE

Answer 8

Compares two SOUNDEX values, and returns an integer value

Question 9

FORMAT

Answer 9

formats a value with the specified format

Question 10

LEFT

Answer 10

extracts a number of characters from a string (starting at the left)

Question 11

LEN

Answer 11

Returns the length of the string

Question 12

LOWER

Answer 12

converts a string to lower-case

Question 13

LTRIM

Answer 13

removes leading spaces from a string

Question 14

NCHAR

Answer 14

returns the Unicode character based on the number code

Question 15

PATINDEX

Answer 15

returns the position of a pattern in a string

Question 16

QUOTENAME

Answer 16

returns a Unicode string with delimiters added to make the string a valid SQL server delimited identifier

Question 17

REPLACE

Answer 17

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

Question 18

REPLICATE

Answer 18

repeats a string a specified number of times

Question 19

REVERSE

Answer 19

reverses a string and returns the result

Question 20

RIGHT

Answer 20

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

Question 21

RTRIM

Answer 21

removes trailing spaces from a string

Question 22

SOUNDEX

Answer 22

returns a four-character code to evaluate the similarity of two strings

Question 23

SPACE

Answer 23

Returns a string of the specified number of space characters

Question 24

STR

Answer 24

Returns a number as string

Question 25

STUFF

Answer 25

deletes a part of a string and then inserts another part into the string, starting at a specified position

Question 26

SUBSTRING

Answer 26

extracts some characters from a string

Question 27

TANSLATE

Answer 27

returns the string from the first argument after the characters specified in the second argument are translated into the characters specified in the third argument

Question 28

TRIM

Answer 28

removes leading and trailing spaces (or other specified characters) from a string

Question 29

UNICODE

Answer 29

returns the Unicode value for the first character of the input expression

Question 30

UPPER

Answer 30

converts a string to upper-case