28 th Jun 2022 21:35:47
Hai Friend , Sign In
Chennai City
G. K.
Tamil Nadu Government Holiday List 2018 in English and Tamil   *   Trichy: Wanted - PHP, MySql Programmers. Contact trichy people only 84894 28 444.   *   Indian Railways New Train Number List [Search / Enquiry / Locator / Finder]   *   பன்றிக் காய்ச்சல் பற்றி அறிந்து கொள்ளுங்கள் (Swine Flu H1N1)
See Also
InStr Function InStr Function
String Functions String Functions
Option Compare Statement Option Compare
Visual Basic Functions Visual Basic Functions
Visual Basic Home Visual Basic Home
Description  Syntax  Return Datatype  Example  Migration

InStrRev Function - Visual Basic 6.0 (VB 6.0)

Returns the position of the first occurrence of one string within another, from the end of string.
InStrRev(stringcheck, stringmatch[, start[, compare]])
Parameter Description
stringcheck Required. String expression being searched.
stringmatch Required. String expression searched for.
start Optional. Numeric expression that sets the starting position for each search. Default -1.
compare Optional. Numeric value indicating the kind of comparison to use when evaluating substrings.

InStrRev Function's compare argument:
Constants Value Description
vbUseCompareOption -1 Performs a comparison using the setting of the Option Compare statement.
vbBinaryCompare 0 Default. Perform a binary comparison.
vbTextCompare 1 Perform a textual comparison.
vbDatabaseCompare 2 Microsoft Access only. Performs a comparison based on information in your database.

Return Data type:

Dim SearchStr as String, SearchChar as String
SearchStr = "Chennaiiq"
SearchChar = "N"

Statement Result Remark
InStrRev(SearchStr, SearchChar, -1, 1) 5 vbTextCompare
InStrRev(SearchStr, SearchChar, -1, 0) 0 vbBinaryCompare
InStrRev(SearchStr, SearchChar, 4, 1) 4 Second occurrence (Reverse)
InStrRev(SearchStr, SearchChar, 6, 1) 0  
InStrRev(SearchStr, LCase(SearchChar)) 5  
InStrRev("", SearchChar) 0  
InStrRev(SearchStr, "") 9 Length of Stringcheck
InStrRev(Null, SearchChar) Error Invalid use of null
InStrRev(SearchStr, Null) Error Invalid use of null
Go to top

Migration from Visual Basic 6.0 (VB 6.0) to
  InStrRev Function in VB Script (VBS)
  InStrRev Function in JScript (JS)
  InStrRev Function in ASP (Active Server Page)
  InStrRev Function in PHP Script
  InStrRev Function in MS-Access
  InStrRev Function in MS SQL Server
  InStrRev Function in Oracle
  InStrRev Function in C Language
  InStrRev Function in C++ Language
  InStrRev Function in Foxpro
  InStrRev Function in Fortran
  InStrRev Function in MS Excel Sheet
Go to top

© 2021 Chennaiiq.com. All Rights Reserved.