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.

select forUpdate myTable
myTable.Description = strUpr(myTable.Description);


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: Logo

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s

%d bloggers like this: