Access 2002 Programming by Example

Access String Functions

The simple reason why it is a good idea to use built-in string functions is that they are very useful to anyone who wants to have a good understanding of development using Microsoft Access. Databases are about data and how data can be manipulated. Queries can manipulate data, but queries have limitations. Suppose you want to pull the first name out of a full name in a field located in a table having 30,000 records. How can you do that in a query without using a string function? You can use an SQL string in VBA, but even there, the best way to extract the data is to use a string function. You also can benefit from using string functions in your own functions to create utilities custom made for your applications.

String ...