Subject Re: indexing with character numbers From Ken Mayer <dbase@nospam.goldenstag.net> Date Sat, 25 Jan 2025 21:00:13 -0800 Newsgroups dbase.getting-started On 1/25/2025 11:15 AM, Charlie wrote: > I am working on a new project.  There is a field which is character.  I want it to act as if it is a number by order.  instead of 723 coming before 98, I would like them in numerical order.  I am importing some of the data from a spreadsheet and it's easier if all rows are character from my experience. > > Would I be better off to just bite the bullet and go with a numeric field instead of character?  Is there some way to have a character to index like numbers? > As Mervyn notes, you have to manipulate it the data. It would be simpler to use a numeric field. Then you don't have to do anything special. Importing from Spreadsheets will attempt to make sense of the data, so if you import a numeric column, it should come in as numeric. Ken -- *Ken Mayer* Ken's dBASE Page: http://www.goldenstag.net/dbase The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm dBASE Web Tutorial: http://www.goldenstag.net/dbase/WebTutorial/00_Menu.htm dBASE DOS to Windows Tutorial: http://www.goldenstag.net/dbase/DtoWTutorial/00_Menu.htm