Re: Comparing strings as ants^H^H^H^Hints

2001-10-30 Thread Sommai Fongnamthip
Some programming language in some platform could compare this string numeric. But, Why not use it in real numeric value (no quote) or use convert method before compare? SF At 13:24 30/10/2001 +0900, Joel Rees wrote: >I don't have any experience with SQL, but I'm thinking that zero filling >bo

Re: Comparing strings as ants^H^H^H^Hints

2001-10-29 Thread Joel Rees
I don't have any experience with SQL, but I'm thinking that zero filling both might work: Although '5' <= '40' is false, '0005' <= '0040' is true. But since you should be using some glue code to validate the field from the web page anyway, can you just push the