.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

charindex

Posted By:      Posted Date: September 08, 2010    Points: 0   Category :Sql Server
 
Hi, How can I return the value after pl i.e. 9900006264 in the string below (the string's length can change)? declare   @w nvarchar (200) set   @w='OTS order with no invoice: 7521 Customer:ARITAN HANAALA VEBIGUD Value: 2105.72 PL:9900006264' Thanks


View Complete Post


More Related Resource Links

charindex sql server 2005

  

hi,

I need to return the number after the pl (78900) and before EI in the string below. How can i do that?

 

declare

 

@str1 nvarchar (500)

set

 

@str1='Partial status for pl: 78900

Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend