-
sort odd/even
From
vjp2.at@at.BioStrategist.dot.dot.co@21:1/5 to
All on Fri Jan 10 12:04:12 2020
Tried concat the three fields and still same
- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus
blog: panix.com/~vjp2/ruminatn.htm - = - web: panix.com/~vjp2/vasos.htm
facebook.com/vasjpan2 - linkedin.com/in/vasjpan02 - biostrategist.com
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)
-
From
vjp2.at@at.BioStrategist.dot.dot.co@21:1/5 to
All on Fri Jan 10 11:42:02 2020
order by street, house, if(mod(right(trim(house),1),2)=0,0,1)
I printed out mod(..) and it is ok but it won't sort by it
is it possible it only sorts on two and no more keys?
It worked on Microsoft
Tried several variants
- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus
blog: panix.com/~vjp2/ruminatn.htm - = - web: panix.com/~vjp2/vasos.htm
facebook.com/vasjpan2 - linkedin.com/in/vasjpan02 - biostrategist.com
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)
-
From
vjp2.at@at.BioStrategist.dot.dot.co@21:1/5 to
All on Fri Jan 10 12:11:19 2020
Got it to work by using only first three chars of house and street.
Kinda lame, but it worked.
- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus
blog: panix.com/~vjp2/ruminatn.htm - = - web: panix.com/~vjp2/vasos.htm
facebook.com/vasjpan2 - linkedin.com/in/vasjpan02 - biostrategist.com
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)