Strings Quick Reference

The following table lists methods to manipulate strings.

Statement	Purpose	Reference
Chr	Converts a character code to a string.	Get ANSI String Method
Format	Returns an expression in a format that you specify.	Set String Format Method
InStr	Returns the position of one string in another string.	Get Substring Position Method
LCase	Converts a string to lower case.	Convert String to Lowercase Method
Left	Returns a string copied from the beginning of another string.	Get Left String Method
Len	Returns the length of a string or size of a variable.	Get String Length Method
Like	Compares the contents of two strings.	Compare Strings Operator
Lset	Copies one string to another string or assigns a custom variable to another variable.	Copy String Method
LTrim	Removes leading spaces from a string.	Remove Spaces From String Method
Mid	Returns a portion of a string.	Get Substring Method
Mid = string	Replaces part or all of one string with another string.	Replace String Method
Option Compare	Specifies the default method for string comparisons to case-sensitive or not case-sensitive.	Set String Comparison Method
Right	Returns the right portion of a string.	Get Right String Method
Rset	Right-justifies one string in another string.	Right-Justify String Method
RTrim	Removes trailing spaces from a string.	Trim Trailing Spaces From String Method
Space	Returns a string of spaces.	Get a String of Spaces Method
Str	Returns the string representation of a number.	Convert Number to String Method
StrComp	Compares two strings.	Compare Strings Method
String	Returns a string that consists of a repeated character.	Get Repeated Character String Method
Trim	Removes leading and trailing spaces from a string.	Trim Spaces From String Method
UCase	Converts a string to upper case.	Convert String to Uppercase Method
Val	Returns the numeric value of the first number that it finds in a string.	Get First Number From String Method