Function to UPPERCASE everything

[kuma_24]

I have a feeling I know the answer, but does anyone know of a function that will change everything in a field to upper case?

In other words I have a field in the database that has information in it that is not uppercase. When I call that field on the web I would like to display all the information in that field in uppercase. Can this be done?

Thanks,

Nick

[andygaunt]

As you are in 7, why not reformat the contents of the field to always be upper case

go into Define database and choose the correct table. Select your field and go to the Options.

There you will see an Auto enter Calc option.

Check this and type in

Upper (FieldName)

Click ok and now uncheck the option Do not replace existing value for field (if any)

Now, each time data is entered in the field it will re-calculate itself and change itself to UPPEr, no matter what the user entered.

[kuma_24]

We are trying to leave the integrity of the field information intact. If there are no functions to do this on the web then we will have to take that route.

Thanks,

nick

[Ender]

I don't work with IWP, but I suppose you've tried the field formatting options?

If that's no good, define a new calc field using that Upper() function. This will leave the original field intact.

[kuma_24]

I think maybe I have not explained the situation well enough. I am looking for either an XML or FMXSLT function on the web in order to uppercase information from fields in the database. So I would like to do something like the following...

Thanks,

nick

[Martin Brändle]