Syntax |
POS(Text, String to find, Start position) |
Description |
Returns the character position of a searched string in text. Returns 0 if not found. |
Example |
POS("Personalized Printing", " ", 1) => 13 |
Text |
Any text expression or data field containing a text. |
String to find |
String to search for. |
Start position |
Position to start search from. |
This function allows you to search for certain character in the value of a database field. The result will be the position of the character you are searching for.