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’)));
Very nice site as well app
ReplyDeleteThank you : )
DeleteWhat is your app's name ?
ReplyDeleteWe do not have any app.
DeleteCan' t we use LTRIM AND RTRIM instead of leading and trailing
ReplyDeleteLtrim and Rtrim are used to trim spaces not characters
DeleteLtrim and Rtrim are used to trim spaces not characters
ReplyDeleteYes.
DeleteThat's why we use leading and trailing as . is a character
ReplyDeleteI am getting error if tried in My SQL cmd line:(
ReplyDeletePlease send me screenshot.
DeletePost a Comment
You can help us by Clicking on ads. ^_^
Please do not send spam comment : )