How to use LEFT function

[kashew]

I just left the MSAccess world and have started to learn BObjects. I have no docs at the present time. Can someone tell me how I enter a condition that will read the first 3 characters of a data field?
example: Left(object,3) equal to 'abc'

 

[GKar]

kashew,

you will find all the BO documentation on your CD in PDF format. You can use the online help as well

From the online help:
- Syntax
Left(character string, number of characters)
- Description
Takes out the specified number of characters from the left of the character string.
-Example
Left("Date of the Order",4) returns Date.


If you want to build an objects in you universe, you have to use the MS Access SQL syntax: left(table.column,3)

Hope it will help you.

GKar