LEFT( )The following example displays the first letter of each name in the CustomerName data field:The following example uses the LEFT( ) and FIND( ) functions to display the characters preceding the hyphen in a product code:LEFT([ProductCode], FIND("-", [ProductCode]))If the product code is ModelA-1234, LEFT( ) returns the following string:
|
|
Copyright Actuate Corporation 2012 |