How to use the instr function in vb
The function of the instr function is to find the first searched string starting from the starting position backwards If the position of the second occurrence is found, its position in the original string is returned, otherwise 0 is returned.
Syntax:
instr( string1, string2, start_position,nth_appearance )
Parameters:
string1: Source string, to be searched in this string.
string2: The string to be found in string1.
start_position: represents the position of string1 to start searching. This parameter is optional and defaults to 1 if omitted. String indexing starts at 1. If this parameter is positive, the search starts from left to right. If this parameter is negative, the search starts from right to left, and returns the starting index of the string to be found in the source string.
nth_appearance: Represents the number of occurrences of string 2 to be found. This parameter is optional. If omitted, the default is 1. If it is a negative number, the system will report an error.
Note:
The position index number starts from 1. If String2 is not found in String1, the instr function returns 0.
Example:
SELECT instr('syranmo','s') FROM dual; -- 返回 1 SELECT instr('syranmo','ra') FROM dual; -- 返回 3 SELECT instr('syran mo','at',1,2) FROM dual; -- 返回 0
PHP Chinese website, a large number of Introduction to Programming tutorials, welcome to learn.
The above is the detailed content of How to use instr function in vb. For more information, please follow other related articles on the PHP Chinese website!

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

PhpStorm Mac version
The latest (2018.2.1) professional PHP integrated development tool

Safe Exam Browser
Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.

SublimeText3 Linux new version
SublimeText3 Linux latest version

MinGW - Minimalist GNU for Windows
This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.