User FAQs

1) What is a String Literal ?
A string can be assigned a literal value that represents a series of characters.

For more information refer to the Literal Constants page.

2) What is the best way to check for an empty string ?
Always check the length of the string using the LEN function.
Avoid comparing with an empty string ("") as this requires 6 bytes of memory.

3) What is the best way to assign an empty string ?
Always assign your string to vbNullString when you need to empty the contents.
Avoid using an empty string ("") as this is slower and takes up more memory.
Zero-Length String ("") - Is an actual string literal and has a size of 6 bytes.
vbNullString - Is a special character that denotes an empty string which is equivalent to zero.

4) How can you include speech marks in a text string ?
You need to use double quotes.

5) How would you declare a Variable Length String ?

6) How would you declare a Fixed Length String with 10 characters ?
A fixed length string is padded with null characters CHR(10) when it is declared.
The CHR returns the character with the corresponding ASCII / ANSI number.

7) How would you check the last 2 characters in a string ?

8) How would you check for specific characters in a string ?
The Like Operator can be used to compare two strings and provide pattern matching.

9) What is the difference between the MID function and the MID statement ?
The MID Function returns a substring from a larger string.

The MID Statement replaces some characters inside a string variable.

10) What is the difference between the LEFT function and the LEFT$ function ?
LEFT - This function can handle Null being passed in as an argument.
LEFT$ - This function cannot handle Null.
For more information refer to the Functions $ page.

11) What is the difference between the vbNewLine constant and the vbCrLf constant ?
There is no difference, they both represent a carriage return and line feed.

12) Can you have this ?
Yes this is valid and defines a subroutine with an optional argument that has a default value of an empty string.

13) What does JSON stand for ?
JavaScript Object Notation
This format is based on a subset of JavaScript's object literal syntax.

14) When is VBScript being retired ?
In 2027 it will no longer be enabled by default and after that it will be removed altogether.