Click here to Skip to main content
Click here to Skip to main content
Add your own
alternative version

Problem with substring

, 3 Oct 2012
Thats because if charindex is not present then substring will become 0-1 =-1 but the index itself starts from 0 and no element would be at -1 index.For eg, if 5/2012D is one of the value, then in substring function it becomessubstring(sender_index_code,1,(0-1)) and it will throw errortry...



Compare Revision Minor Date Status Editor
publicly available No 4-Oct-12 3:42 Available Santhosh Kumar Jayaraman
Updates in content. 118 changes had been made.
2 No 4-Oct-12 3:34 Available Santhosh Kumar Jayaraman
Updates in content. 7 changes had been made.
1 No 4-Oct-12 3:29 Available Santhosh Kumar Jayaraman


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

About the Author

Santhosh Kumar Jayaraman
Software Developer Education First
India India
Started my career with Infosys in 2009 and currently working with Education First. I have great passion towards Microsoft technologies. I have experience in Microsoft technologies like WPF, WCF, ASPNET, WinForms,Silverlight, VB.NET, C-Sharp, Entity framework,SSRS, LINQ, Extension methods and SQL server.

| Advertise | Privacy | Mobile
Web04 | 2.8.140721.1 | Last Updated 4 Oct 2012
Article Copyright 2012 by Santhosh Kumar Jayaraman
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid