[Microsoft Access] LIKE condition, using wildcard

This MSAccess tutorial explains how to create a query using the LIKE condition with wildcards in Access 2007 (with screenshots and step-by-step instructions).

The LIKE condition allows you to use wildcards in the where clause of a SQL statement in Access 2007. This allows you to perform pattern matching. The LIKE condition can be used in any valid SQL statement - select, insert, update, or delete.
The patterns that you can choose from are:

 Here is an example of how you'd use the LIKE condition in a query:

In this example, we are looking for all employee last names that start with "m".
Combining the LIKE condition with the NOT operator

You can also combine the LIKE condition with the NOT operator.

Here is an example of how you'd use the NOT LIKE condition in a query:

In this example, we are looking for all employee last names that do not start with "m".


::source::

[Microsoft Excel] Combine Two Cells into One Cell

In this example, a text file has been imported into Excel. First names and last names are in two separate columns. To combine the information into one cell, you would use a formula that is unlike what you've seen before. It uses the ampersand (&) operator instead of a function. You would type this formula in cell C2:

=A2&" "&B2

The ampersand tells Excel to combine the text from cell A2, and a space (identified by the quotation marks around it), and the text from cell B2.

To combine the other names into other cells in column C, you would copy the formula down the column.

Note     You can do the same operation by using the CONCATENATE function: =CONCATENATE(A2," ",B2), but it's faster to just type the ampersand. "Concatenate" means to combine, by the way, or had you guessed?
::source::