What is the difference between SUBSTRING and CHARINDEX function in the SQL Server?
Technology
Web App Development
Mobile App Development
Windows App Development
Database Development
UI/UX Development
Cloud Development
SEO
Digital Marketing
Guest Posting
Content Writing
Artificial Intelligence
Data Science
ERP Development
CRM Development
CMS Development
LMS Development
Business Listing
Blockchain Technology
Startup Promotion
AI Tools Integration
Jr software developer trainee
Myself Ashutosh Kumar Verma from Varanasi. I am a Software Developer in MindStick Software pvt. ltd. Prayagraj. I have completed my MCA from VBSP. University, Jaunpur in 2021.
Can you answer this question?
Write Answer1 Answers
SUBSTRING() in SQL:
The SUBSTRING() function is returns a part of given string or we can say this function is extract some characters from given string.
Syntax – SUBSTRING(String, start, Length);
Example-
CHARINDEX() in SQL:
CHARINDEX() function is searches for a substring from String and returns the position or index number of particular substring from given String. If substring is not found then it returns 0.
Syntax- CHARINDEX(substring, string, start);
Start is optional in CHARINDEX() function.
Example-
In the following SQL statement the start number is provide where the searching is start. By default the starting position is 1.