generate qr code using vb.net LIKE Wildcard Characters in Visual Studio .NET

Printer Code 128 in Visual Studio .NET LIKE Wildcard Characters

Any single character Zero or more characters; used to define leading, trailing, or embedded strings that don t have to match any specific pattern characters Any single digit

* #

LIKE ##### or LIKE #####-#### LIKE [A-Z]#[A-Z] #[A-Z]# LIKE ###-##-#### LIKE Smith* LIKE *smith##*

A U.S. 5-digit ZIP Code A U.S. 9-digit ZIP+ Code A Canadian postal code A string that begins with Smith* A string that contains smith followed by two numbers, anywhere in the string A U.S. Social Security Number

4

4

You can also specify that any particular position in the Text or Memo field can contain only characters from a list that you provide. You can specify a range of characters within a list by entering the low value character, a hyphen, and the high value character, as in [A-Z] or [3-7]. If you want to test a position for any characters except those in a list, start the list with an exclamation point (!). You must enclose all lists in brackets ([ ]). You can see examples of validation rules using LIKE here.

4

4

If you need to validate a Text, Memo, or Hyperlink field against a matching pattern (for example, a postal code or a phone number), you can use the LIKE comparison operator. You provide a text string as a comparison value that defines which characters are valid in which positions. Access understands a number of wildcard characters, which you can use to define positions that can contain any single character, zero or more characters, or any single number. These characters are shown in Table 4-5.

4

4

4 4 4 4 4 4

An eight-character string that contains any first two characters followed by exactly two zeros and then any four digits A string that contains any character other than a number or the letter B, M, or Q in the first position and ends with exactly four digits

LIKE 00#### LIKE [!0-9BMQ]*####

* Character string comparisons in Microsoft Access are case-insensitive. So, smith, SMITH, and Smith are all equal.

To assist you in entering formatted data, Access allows you to define an input mask for Text, Number (except Replication ID), Date/Time, and Currency data types. You can use an input mask to do something as simple as forcing all letters entered to be uppercase or as complex as adding parentheses and hyphens to phone numbers. You create an input mask by using the special mask definition characters shown in Table 4-6. You can also embed strings of characters that you want displayed for formatting or stored in the data field.

Table 4-6.

A single digit must be entered in this position. A digit or a space can be entered in this position. If the user skips this position by moving the cursor past the position without entering anything, Access stores nothing in this position. A digit, a space, or a plus or minus sign can be entered in this position. If the user skips this position by moving the cursor past the position without entering anything, Access stores a space. A letter must be entered in this position. A letter can be entered in this position. If the user skips this position by moving the cursor past the position without entering anything, Access stores nothing. A letter or a digit must be entered in this position. A letter or a digit can be entered in this position. If the user skips this position by moving the cursor past the position without entering anything, Access stores nothing. A character or a space must be entered in this position. Any character or a space can be entered in this position. If the user skips this position by moving the cursor past the position without entering anything, Access stores nothing.