Re: Sorting issue

One last question. I changed all the DB values where numbers are used - (varchar - int) But for the well locations, there are dashes in them, I.E. 10-15-065-22 With setting the field to int, it only displays the first part. 10-15-065-22 shows as 10 There are also several other fields that use dashes. If I set it back to varchar, will it sort it right because the numbers are separated by an alfa character, or will I have the same problem as before? "Jeff" <jroth1@telus.net> wrote in message news:20030808165642.47278.qmail@pb1.pair.com... > Thank you EVERYONE.. AGIAN! *grin* > > > > "John W. Holmes" <holmes072000@charter.net> wrote in message > news:3F33D254.9020409@charter.net... > > Jeff wrote: > > > > > Yes duh... > > > > > > I didn't realize numbers weren't considered characters. > > > What's the sql entry for numeric characters? > > > > > > I'm new at this, and figure I'm not doing to bad so far. . > > > > Make them an INT column. It'll hold numbers up to 2 billion+. Or you can > > use TINYINT which will hold numbers up to 255. Read the MySQL docs for > > more column types... > > > > kwo INT NOT NULL, > > lsd INT NOT NULL, > > > > -- > > ---John Holmes... > > > > Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ > > > > PHP|Architect: A magazine for PHP Professionals - www.phparch.com > > > > > > > > > >