Aware IM User Forums

Is it a way to use the REPLACE function to replace all capital letters with low case?

Can I remove an empty space with the REPLACE function? greg You can use the "REPLACE" function to replace the punctuation characters that you specify with an empty string. To be able to use this solution for your problem you will need to do the following: a) Get the product to store the catalog numb...

I have set up a query which searches my BO (business object) and returns a number of instances of the BO. The results are displayed as a presentation. The presentation title has a field << SUM BO. Attribute>> where Attribute is a number. However this field displays null regardless if the query retur...

In supply and distribution application I am developing, I store product catalogue numbers and then allow users to search and to re-use products already entered on the database. A problem was identified with longer catalogue numbers that users tend to enter the same number in different ways by insert...