I'm trying to 'ORDER BY' a String field which contains numbers. It orders like this:
1 10 2 3 ...
I've tried whith LPAD, VALUE, *1, but nothing works.
THANKS all for ur help!
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.Sign up to join this community
Two possible options I can think of right now: