Mitch Vincent writes:
> I can't cast varchar to int (according to the error I'm getting..), any
> ideas on how I can accomplish a ranged search on a varchar field (taking
> into acount the value of the numbers, not the character's ascii code)?
Try casting it to text first:
cast(cast(value as text) as integer)
--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/