Question

Q3. Implement following string functions in SQL.

a) LTRIM

b) RTRIM

c) CONCAT

d) INSTR

​

Answer 1

Answer:

Appending the string. Strcmp(str1,str2): Returns -ve value if str1 is less than str2;0 if str1 is equal to str2; and >0 (+ve value) if str1 is greater than str2. Strcpy(str1,str2): Replace the content.