To/From Code

	Languages
BROWSEBYLANGUAGE Access VBA ASP Classic C# C++ C++/CLI Corel Paradox Delphi Delphi Prism Java JavaScript Perl PHP VB Classic VB.Net

	Categories
BROWSEBYCATEGORY +Tool Basics +Language Basics +Language Details +Data Structures +Statements +Operators +Commands +Database +OOP Basics +OOP Details

	VB.Net Guides
VB.Net To/From Conversion Guides VB.Net and ASP Classic VB.Net and C# VB.Net and C++ VB.Net and C++/CLI VB.Net and Corel Paradox VB.Net and Delphi VB.Net and Delphi Prism VB.Net and Java VB.Net and JavaScript VB.Net and Perl VB.Net and PHP VB.Net and VB Classic

Cross Ref Guide

VB.NETLANGUAGE

VB.Net

VB.NETANDACCESS VBATOC

Overview

+Tool Basics

Report Tools Overview

+Language Basics

+Language Details

+Data Structures

Array

+Statements

+Operators

+Commands

Left of String◄╣

+OOP Basics

+OOP Details

	Members-Only
Sign in to see member-only pages.

► KB ► To/From Guides ► VB.Net

Print This

Left of String (VB.Net and Access VBA Cross Reference Guide)

By Mike Prestwood

VB.Net versus Access VBA: A side by side comparison between VB.Net and Access VBA.

Commands

Common commands (procedures and functions). A function returns a value. Optionally, it may also perform an action prior to returning a value. A procedure does not return a value or it returns void or null.

Left of String

[Other Languages]

VB.Net: "Left of Substring" Left or Substring

The above usage of Left and Substring are equivalent.

Left is a traditional VB approach popular with developers moving from VB Classic to VB.Net. Substring is considered the .Net way of doing string manipulation.

Syntax Example:

Dim FullName

FullName = "Prestwood"
Console.WriteLine("Hello " + Left(FullName, 4))
Console.WriteLine("Hello " + FullName.Substring(0, 4))

Access VBA: Left

Syntax Example:

Dim LeftString As String

LeftString = Left("Prestwood", 3)

MsgBox LeftString