R radek225 Registered User. Local time Yesterday, 21:17 Joined Apr 4, 2013 Messages 307 Nov 25, 2015 #1 I have a query with "order by LP asc" (lp is a number) but the problem is when the lp is null (has no value) then these rows are on top. What should I do to have rows with no value at the bottom?
I have a query with "order by LP asc" (lp is a number) but the problem is when the lp is null (has no value) then these rows are on top. What should I do to have rows with no value at the bottom?
C CJ_London Super Moderator Staff member Local time Today, 05:17 Joined Feb 19, 2013 Messages 17,530 Nov 25, 2015 #2 try order by nz(LP,1000000) make the number as big as it needs to be to be the biggest
P plog Banishment Pending Local time Yesterday, 23:17 Joined May 11, 2011 Messages 12,003 Nov 25, 2015 #3 ORDER BY NZ(LP, 999999) If you have LP values greater than 999999, use a value greater than your largest LP value.
ORDER BY NZ(LP, 999999) If you have LP values greater than 999999, use a value greater than your largest LP value.
P plog Banishment Pending Local time Yesterday, 23:17 Joined May 11, 2011 Messages 12,003 Nov 25, 2015 #4 Damn it CJ, that's twice today. I'm getting closer though, this time I was only a minute behind.
