Martijn Tonies wrote:

>A stored procedure uses the exact same logic as a normal query.
>
>You can _compare_ an integer to a char field just fine. The problem
>comes with your "less than" ( <= ) and greater than. These behave
>different on char colmns. Without trying, did your second attempt
>return the right results?
>
>

Yes I have try it many times, and it returns the same results

>And another question: if you're storing numbers, why not use an Integer
>type column?
>
>

I'll consider that suggestion =)

Thanks a lot.

James

>With regards,
>
>Martijn Tonies
>Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
>Server.
>Upscene Productions
>http://www.upscene.com
>
>
>
>
>Yahoo! Groups Links
>
>To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
>To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>Your use of Yahoo! Groups is subject to:
> http://docs.yahoo.com/info/terms/
>
>
>
>
>
>