Search All Articles 
Thursday, November 13, 2008
What is difference between SUBSTR and INSTR in the SQL?
SUBSTR returns a specified portion of a string
Example: SUBSTR('BCDEF',4)
The result will be: BCDE
INSTR provides character position in which a pattern is found in a string.
Example: INSTR('ABC-DC-F','-',2)
The result will be: 7 (2nd occurence of '-')
Subscribe to:
Post Comments (Atom)
Also Read other Top Articles
- JSON Serialization in VS 2008
- Implementing Forms Authentication in Silverlight Application.
- Making GridView Rows or Individual Cells Clickable and Selectable.
- Enabling browser back button for GridView Paging and Sorting in Ajax 1.1 and 3.5 (using Visual Studio 2005/ Visual studio 2008)
- How to pass values from User Control to Page or calling Page methods from User Control.
- What is WCF?
- New features in C# 4.0
- C# to VB.NET and VB.NET to C# online free converter tools.
Latest Articles
0 comments:
Post a Comment
Post your comments/questions/feedback for this Article.