Changing existing table data to uppercase

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've inherited a database and the db manager is wanting all the existing data
changed to uppercase (ostensibly to facilitate migration to SAP). I'm
wondering if there a relatively easy way to change the existing data to all
uppercase. I've advised him about the "no going back" issue, and the option
that we can set reports and forms to display in uppercase, but he is
insistant that the raw data needs to be uppercase.

As an aside, is this really an SAP requirement (all data has to be entirely
uppercase), susposedly to make searches easier? I've given him the look my
dog gives me when he doesn't understand, but so far the manager hasn't thrown
me a bone.
 
Dan said:
I've inherited a database and the db manager is wanting all the
existing data changed to uppercase (ostensibly to facilitate
migration to SAP). I'm wondering if there a relatively easy way to
change the existing data to all uppercase. I've advised him about the
"no going back" issue, and the option that we can set reports and
forms to display in uppercase, but he is insistant that the raw data
needs to be uppercase.

As an aside, is this really an SAP requirement (all data has to be
entirely uppercase), susposedly to make searches easier? I've given
him the look my dog gives me when he doesn't understand, but so far
the manager hasn't thrown me a bone.
Click to expand...

If SAP is a case sensitive database then they might want all upper case data
so that criteria entered in mixed case can be converted to upper case and
then a direct comparison made rather than having to apply criteria to an
expression that converts the data to upper case (that would be slower).

UPDATE TableName
SET FieldName = UCase(FieldName)
 
Back
Top