Q. If Str = "INFORMATICS PRACTICES …." and Str1 = "... FOR CLASS XI"

Write commands to print the output as 'informatics practices for class xi'.


Answer =

SELECT CONCAT (LOWER (TRIM (TRALING ‘.’ FROM ‘INFORMATICS PRACTICES ….’)), LOWER (TRIM (LEADING ‘.’ FROM ‘... FOR CLASS XI’)));

11 Comments

You can help us by Clicking on ads. ^_^
Please do not send spam comment : )

  1. Very nice site as well app

    ReplyDelete
  2. What is your app's name ?

    ReplyDelete
  3. Can' t we use LTRIM AND RTRIM instead of leading and trailing

    ReplyDelete
    Replies
    1. Ltrim and Rtrim are used to trim spaces not characters

      Delete
  4. Ltrim and Rtrim are used to trim spaces not characters

    ReplyDelete
  5. That's why we use leading and trailing as . is a character

    ReplyDelete
  6. I am getting error if tried in My SQL cmd line:(

    ReplyDelete

Post a Comment

You can help us by Clicking on ads. ^_^
Please do not send spam comment : )

Previous Post Next Post