Sort on last four characters of string

P

Patrick Fonck

Guest
I have fields with numbers like these...

551.91.1234
552.46.1345
553.45.3456

...and would like to sort only on the last four characters, ignoring the first seven. I'd like to keep the fields as-is, not separating them in separate columns which would make sorting easier.
Can anyone tell my how to do this? I'm no good at PHP but can modify some lines ;-)

Thanks!
 
Top