Upper Case All fields

[saumyashah90]

Hi .

I have 100 fields to pull.

i want to use Select *,
i want to do upper case for all at once?

Can we do it?

[Anonymous]

You can use Upper(FieldName)?

[saumyashah90]

I dont want to do it for single field name.

I want to make it for all together

[Chanty4u]

Upper(fieldname)

or

prior to the Load statement.

Force Case Upper;

[Anonymous]

I do not think so, it would be possible....

You have to define it for every field one by one...

[Chanty4u · Accepted solution]

chk dis