|
Syntax |
MID(Text, Start position,Size) |
|
Description |
Extracts characters from the supplied text, starting at the character position specified by start position and containing the number of characters specified by size. |
|
Example |
MID ("Personalized Printing", 5, 4) => onal |
|
Text |
Any text expression or data field containing a text. |
|
Start position |
Any numeric expression or data field containing a number (start position to get characters from). |
|
Size |
Any numeric expression or data field containing the number of characters to get. |
This function allows you to print a number of characters of the value in the defined database field.
With MID, you can decide which character you want to start with and how many characters from that point onwards you want to print.