Scribd
Upload
31 views1 page

SUBSTR vs INSTR in SQL Explained

SUBSTR() returns a substring from a given string based on the starting position and number of characters specified. INSTR() returns the position of the first occurrence of a substring within a string, allowing specification of a starting position and occurrence number.

Uploaded by

lixo healthcare
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
31 views1 page

SUBSTR vs INSTR in SQL Explained

SUBSTR() returns a substring from a given string based on the starting position and number of characters specified. INSTR() returns the position of the first occurrence of a substring within a string, allowing specification of a starting position and occurrence number.

Uploaded by

lixo healthcare
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

Difference between SUBSTR() vs INSTR()

*****************************************
SUBSTR  Returns specific portion of a string
 SUBSTR(3)  Accepts three arguments
1  Input_string
2  starting_position
3  total number of position to display

INSTR(4) Returns character position in a pattern of string


Accepts four arguemnts
1 Input_string 2String2Search 3Starting_position 4Occurrence

You might also like