String Functions

Name the string function which combines more than one string

• combine

• instr

• concat

• substring

name the function which gives the position of the first occurrence of second string in first string

• concat

• instr

• mid

name the function which returns that specified number of characters from the beginning of the string

• substr

• left

• right

what will be output for

select instr("formating", "4")

what will be the output for

conact("class","XII",NULL)

write the output for

select mid('pandemic year', 2,3);

write the output for

select right('informatics practices',5);

select length("grade XII")

Name the string function which removes the trailing spaces from the given string

write the output for

select mid('informatics,-6,3)