Generally, this variable will be set from user input such as order 101 being selected from a list. The second variable, sqlBase, is set to the first part of the SQL statement with the first variable added to the end. This would allow changing the SQL statement based on user input. This is exactly like the string created with the numeric literal and would produce the same results. Strings Numbers are relatively straightforward as the examples above show.
Strings are more complicated.
Numbers inside of SQL statements are not encased in single quotes. Consider the following example. The status that is wanted, 'open', is entered directly into the string. The entire string is enclosed in double quotes. I mentioned above that in Active Server Pages, all strings are enclosed in double quotes.