Use SQL Function with v9 Business Object

Tony Tran

How do you use the SQL function with Business Object to express the select statement below....

Select Field1, Field2 From TableX Where Len(Field2) <> 0 ?

Jerome_Pearce

I.m not sure you can do this easily with the SQL Builder. Best idea is write the SQL and see if the SQL Builder can interprest it, and how it does.

 

For eaxample, I can add and edit (in the SQL Builder) the following:

 

 

---

SELECT eFolder.eFolderID, eFolder.eFolderName
FROM eFolder
WHERE Len(eFolder.eFolderName) > 10

---

 

Tony Tran

Found the solution. Thanks