Upper case and Lower case in Customquery

[Varshi_Balaji]

Hi Team,

Can anyone give any example how we can user uppercase and lower case function in customquery.

Regards,

Varshita

[rushikeshvartak]

update users set customproperty1 =lower(firstname), customproperty2 = upper(firstname) where username='admin' limit 1;

[Varshi_Balaji]

Hi Rushikesh,

Can we use case also in customquery?

Requirement is we need to combine case statements , upper and lower functions.

Thanks,

Varshita

[rushikeshvartak]

Yes all sql function works 

update users set customproperty1 = case when userkey=1 then lower(firstname) else null end , customproperty2 = upper(firstname) where username='admin' limit 1;