|
Here is example that demonstrates simple use of two important of string
functions in Jet SQL:
MID() and UCase().
In this example we will construct employee name from first and last names converting
begining character of each name to Upper case:
SELECT e.EmpNo,
Trim(UCase(Mid(e.FirstName,1,1))) + Trim(Mid(e.FirstName,2))
+ ' ' +
Trim(UCase(Mid(e.LastName,1,1))) + Trim(Mid(e.LastName,2)) AS EmpName
FROM Employees AS e
|
The query returns results like these:
| EmpNo | EmpName |
| 1 | John Silver |
| 2 | Gret Garbo |
| 3 | Le Chen |
| 4 | Daniel Defo |
| 5 | Maggi Forth |
|