The beginswith operator returns true if the value on the left starts with the value on the right, false if it doesn’t.


This operator has two parameters:

value1 – The first numeric or text value.

value2 – The second numeric or text value.


The beginswith operator compares two values (usually text) to see if the value on the left starts with the value on the right.

"abcdef" beginswith "abc" ☞ true
"abcdef" beginswith "bcd" ☞ false
12345 beginswith 12 ☞ true
12345 beginswith 23 ☞ false

As the final two examples show, the beginswith operator can work with numbers as well as text – it simply automatically converts the number into text before comparing.

As a more practical example, the formula below will be true if the Address field or variable starts with the letters p.o. box.

Address beginswith "p.o. box"

This formula will be true if the if the address is P.O. Box 5328, and false if the address is 6938 Wilson Road.

Note: The beginswith operator does not worry about upper or lower case, so P.O. BOX 5328 or p.o. box 5328 will also produce true results. If upper and lower case are important to you use the matchexact operator.

See Also


10.0UpdatedCarried over from Panorama 6.0, but also now allows numeric as well as text parameters.