how to capitalize all letters

There is a function available in AX strUpr(‘any string’) that can be used to convert the string to upper case.

ttsBegin;
while
select forUpdate myTable
{
myTable.Description = strUpr(myTable.Description);
myTable.update();
}
ttsCommit

Advertisements

One Response to how to capitalize all letters

  1. Ian Schofield says:

    Does anyone know how to capitalise a column of values, though?
    select firstonly state
    where state.CountryRegionId == _countryRegionId
    && state.Name == strUpr(_stateName);

    The strUpr function does not work on the “state.Name” column. In TSQL it’s the Upper function.
    Can it even be done? Thanks!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: