The SUBSTR functions allows you to extract a substring from a string. The syntax for the substr function is:
SUBSTR ( string, start_position, [ length ] )
Where
- string is the source string.
- start_position is the position for extraction. The first position in the string is always 1.
- length is optional. It is the number of characters to extract. If this parameter is omitted, substr will return the entire string.
Note:
- If start_position is 0, then SUBSTR treats start_position as 1 (ie: the first position in the string).
- If start_position is a positive number, then SUBSTR starts from the beginning of the string.
- If start_position is a negative number, then SUBSTR starts from the end of the string and counts backwards.
- If length is a negative number, then SUBSTR will return a NULL value.
For Example:
- SUBSTR ('This is a Informatica blog', 11, 11) return 'Informatica'
- SUBSTR ('This is a Informatica blog', 11) return 'Informatica blog'
- SUBSTR ('This is a Informatica blog', -4, 4) return 'Blog'
- SUBSTR ('This is a Informatica blog', -16, 4) return 'Info'
I am William..
ReplyDeleteI just browsing through some blogs and came across yours!
Excellent blog, good to see someone actually uses for quality posts.
Your site kept me on for a few minutes unlike the rest :)
Keep up the good work!Thanks for sharing a important information informatica
Nice article.
ReplyDeletefor informatica interview questions and answers click here
This is very informative and this is very usefull to us.
ReplyDeleteInformatica online training , informatica training in bangalore
informatica online training , informatica training in bangalore , informatica training , informatica online trainig in bangalore
THis is very nice infromatiom
ReplyDeleteinformatica training , infromatica online training, informatica training in bangalore, infromatica online training in bangalore
ReplyDeletePrivileged to read this blog on Informatica.Commendable efforts to put on research the Informatica.Please enlighten us with regular updates on Informatica.Friends if you're keen to learn more about AI you can watch this amazing tutorial on the same.
https://www.youtube.com/watch?v=56vMQ1lG-vc
World777 online book
ReplyDelete1 bhk flat in ajmer
class 9 tuition classes in gurgaon
kurti palazzo set
sanganeri print sarees
azure firewall
azure blueprints
azure resource group
azure application gateway
azure express route
Elevate your online presence with powerful dedicated server atlanta.. Explore our Frankfurt options for global reach. Experience unmatched performance and reliability for your business needs.
ReplyDeleteEscape to a luxurious best resort in jaipur, where royal elegance meets modern comfort. Enjoy world-class amenities, serene landscapes, and unforgettable experiences.
ReplyDelete