Changing Cases of data

[Former Member]

Hi Experts,

When i am executing Select query to get data from database table it is converting the data into upper case.

I dont want to change the case to upper case. It should remain the same i.e letter which are uppercase shold remain uppercase and the ones which are in lowercase should remain lowercase.

Please help to get this.

Regards,

Akriti

[Former Member]

Hi,

may be the data is in uppercase in data base table also thats why you are uppercase data otherwise by default whatever data in Database will get the same data only, it wont change by default.

Thanks,

Sree

[Former Member]

Ok..

Thanks for the help Polu

[krishna_k19]

Hi Akriti,

    Please check the field domain characteristics , then you come to know whether the values are maintained in Lower Case or upper case.

If you want to change to upper / lower while displaying use conversion rule.

Regards,

Krishna

[Former Member]

Yes Krishna..

I checked that.. but in case of standard database table i cannot change that.

Regards,

Akriti

[Former Member]

Hi,

if the data is in uppercase in database table and you want it to convert to lower case then you can conevrt the data using conversion statement in your program otherwise you dont have any options.

Thanks,

Sree

[Former Member]

Ok..Thanks Sree