Re: using string instead of int

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Other than math calculations, sorting will definitely be a problem, since
text is sorted much differently than numbers
For instance 111 will come before 20, when sorting by text


David Wier
http://aspnet101.com
http://iWritePro.com - One click PDF, convert .doc/.rtf/.txt to HTML with no
bloated markup


"mavrick_101" <mavrick101@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:209EF7DD-B52E-4F4C-8F7B-0BF766F3035F@xxxxxxxxxxxxxxxx
Often in code, when retrieving a value from table where I don't have to do
any math calculations, I store the value in a string variable instead of
converting to an int and then storing in an int variable.

Do you guys see anything wrong with this practice?




.

Relevant Pages

  • Re: Sorting Days of the Week
    ... does this go in the sorting and grouping part of the report: ... MS Access MVP ... "Duane Hookom" wrote: ... you should be storing a date or a number rather than text day names. ...
    (microsoft.public.access.reports)
  • Re: Sorting
    ... What are these storing? ... If you work with real date fields, sorting will be much easier since you can ... pull out the month number and sort by that. ... by the Year first, then the month, BUT in the correct order: ...
    (microsoft.public.access.gettingstarted)
  • Re: Data structure for finding min of set intersection
    ... about worst case asymptotic running time in theory, ... techniques that might be effective in practice. ... sorting the sets might run much faster than Thetatime ... a little more about the common case, about the distribution on problem ...
    (comp.theory)
  • Re: convert text to number
    ... As Allen mentioned, if you must store the numeric values as text, then ... storing them with leading zeros is the way to go. ... I am facing problem of sorting text field, ...
    (microsoft.public.access.queries)
  • Re: simple list efficiency question
    ... chrisd@gamow.sci.kun.nl (Chris Dams) writes: ... >fashion. ... >get away with storing them in a vector and after they are all read in ... Because sorting is (if the order in which the objects are ...
    (comp.lang.cpp)