Difference between revisions of "CHARACTER BUILT IN FUNCTIONS"
Jump to navigation
Jump to search
(Created page with "==UPPER()== UPPER('john') = JOHN ==LOWER()== LOWER('John')=john ==LENGTH()== LENGTH('JOHN')=4 ==SUBSTR()== '''RETURNS PART OF A STRING''' SUBSTR('JAMES',2,3)=AME ==DECODE...") |
(No difference)
|
Revision as of 19:23, 5 November 2017
UPPER()
UPPER('john') = JOHN
LOWER()
LOWER('John')=john
LENGTH()
LENGTH('JOHN')=4
SUBSTR()
RETURNS PART OF A STRING
SUBSTR('JAMES',2,3)=AME
DECODE()
RETURNS THE VALUE MATCHING THE CONDITION
DECODE(20,10,'TEN',20,'TWENTY',30,'THIRTY') = TWENTY