What is difference between SUBSTR and INSTR?
Q
What is difference between SUBSTR and INSTR?
✍: Guest
A
INSTR function search string for sub-string and returns an integer indicating the position of the character in string that is the first character of this occurrence. SUBSTR function return a portion of string, beginning at character position, substring_length characters long. SUBSTR calculates lengths using characters as defined by the input character set.
2011-12-19, 5032👍, 0💬
Related Topics:
What are various joins used while writing SUBQUERIES?
What are various joins used while writing SUBQUERIES? =, , IN, NOT IN, IN ANY, IN ALL, EXISTS, NOT EXISTS. 2011-12-23, 4002👍, 0💬