Easy to Create, Easy to Change - Easy to use!

Function::String

Upper

Parameters

Returns/Result

Examples

Reference

upper

Type

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