Searching query

This topic is locked

Searching query	9/5/2004 7:02:13 AM
ASPRunnerPro General questions
author I have a database that has a field in it with numbers, like 90, or 1145 ect but when I try and sort by the numbers i get them into weired order that 1145 is higher than 90 is there a way to fix this, the numbers are for times. Thanks


	Sergey Kornilov admin 9/9/2004
	Hi, you need to make sure that this field type is Number/Numeric. It sounds like currently this field is a text field which sorted differently.