Doron,
Depending on whether there are a lot of fields or only a few
REPLACE ALL ;
cField1 WITH UPPER(cField1), ;
cField2 WITH UPPER(cField2), ...
Alternatively, use AFIELDS() to get an array of the field names and types, and loop through the resulting array looking for character fields and do your replace.
Table size isn't as important as the number of fields in determining how you go about this.
Also, you want to make sure how new values are added before you fix it all up or you'll have to do it again.
>Hi All,
>
>I have a table 1.5GB is there any easy way to convert all fields
>to upper case.
>
>Thanks,
>
>Doron