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

mPDF
mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),

VSCode Windows 64-bit Download
A free and powerful IDE editor launched by Microsoft

EditPlus Chinese cracked version
Small size, syntax highlighting, does not support code prompt function

MantisBT
Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.

SublimeText3 Chinese version
Chinese version, very easy to use