Function::String
Upper 
Parameters
Returns/Result
Examples
Reference
upper
Type
Text Function
Purpose
The upper function converts each letter in a text value to uppercase.
Syntax
upper( TEXT VALUE)
Returns
The specified text value with all the letters in uppercase.
The upper function only affects the alphabetical letters a-z. Numeric values are not converted to their Shift key equivalents.
Examples
upper( "DataEase" )
Returns: DATAEASE
upper( "Cancun" )
Returns: CANCUN
upper( LAST NAME)
Returns the value in the LAST NAME field in uppercase type for every record processed. If a record contains the value Birnbaum in the LAST NAME field, the function returns BIRNBAUM.
See Also
On the forum about Upper
Text Field will not go in (Proper) or (Upper) case
My Field Company and Town will not change to Upper case. Some fields do but a couple don't. Any fix or work around appreciated....
Product: Dataease [{8}]FIVE. Written by Dave Clements 12/12/14 at 20:03:52
Re:Text Field will not go in (Proper) or (Upper) case
Is the fields read-only or virtual and what is the derivation?...
Product: Dataease [{8}]FIVE. Written by DataEase 12/12/14 at 22:16:22
Re:Re:Text Field will not go in (Proper) or (Upper) case
Plain text field - Required and Indexed - derivation - proper (cotown) some other fields in the form work but at least two don't. ...
Product: Dataease [{8}]FIVE. Written by Dave Clements 12/12/14 at 22:20:46
Re:Re:Re:Text Field will not go in (Proper) or (Upper) case
Proper will only make the first letter Capital so: dAVE would be DAVE and dave would be Dave and DAVE would still be DAVE. In these cases we need to see a sample that showcase the problem as anything else would just be guessing. A...
Product: Dataease [{8}]FIVE. Written by DataEase 12/12/14 at 22:28:40
Re:Re:Re:Re:Text Field will not go in (Proper) or (Upper) case
Done all that but still doesn't work. Works on most fields but three it doesn't. ...
Product: Dataease [{8}]FIVE. Written by Dave Clements 13/12/14 at 11:22:13
Re:Re:Re:Re:Re:Text Field will not go in (Proper) or (Upper) case
OK! We love it when you guys think we are psychics but sorry, cant do anything about it without seeing it so either you need to upload a sample that show it here, or you need to figure it out on your own ;-)...
Product: Dataease [{8}]FIVE. Written by DataEase 13/12/14 at 11:41:35
Re:Re:Re:Re:Re:Re:Text Field will not go in (Proper) or (Upper) case
Here is a screen shot, full database is very large and sample wouldn't work as some fields it works on. See company town and postcode fields. ...
Product: Dataease [{8}]FIVE. Written by Dave Clements 13/12/14 at 11:49:57
Re:Re:Re:Re:Re:Re:Re:Text Field will not go in (Proper) or (Upper) case
Thanks for that, but the problem wasn't that I didn't belive you ;-)Obviously if I try to replicate it, I don't get a problem...So if you can't send anything, then you simply need to test.Change the length of the field or somet...
Product: Dataease [{8}]FIVE. Written by DataEase 13/12/14 at 12:18:56
On the blog about Upper
Extension to GetCurrent() Find the xpos/ypos of the scrolled window (upper left corner) (Ver. 8.5.0.2096)
Download Sample
We have extended the sample used in the previous post to include a Timer(Event...
Product: Dataease [{8}]FIVE. Written by DataEase 08/01/16 at 15:37:13
Register
Sign In
