STARTSWITH
Returns true if expr1 starts with expr2. Both expressions must be text or binary expressions.
Syntax
STARTSWITH( <expr1> , <expr2> )
Example
select * from /shared/examples/ds_inventory/tutorial/suppliers
where startswith(suppliername, 'A');