[thelist] ok, simple asp string compare problem.

[Scott Dexter]

--- Brian Delaney <brian.delaney at mccmh.net> wrote:

> Thanks to all - it turned out that in my sql db I was using 
> char(10)  
> which left  empty characters. If I used the int then the ascii
> didn't 
> match the
> string comparison. SO I changed the data type to varchar(4) and it

Is there some other reason the field in the database isn't a numeric
field (such as smallint or int?)

(If you're working with numeric data, type it as such :) )

sgd