I'm sorry, my mistake. The type definition is
 *nloc_num,ins_numero and ins_digi are decimal(5,0)

2005/10/11, Luciano Centeno <[EMAIL PROTECTED]>:
> hello, my friends, the query "option 1" return the right value,
> the query "option 2" not. Why concat function make the difference?
>
>
> *nloc_num,ins_numero and ins_digi are decimal(3,0)
>
>
>
> /////////////////////////////////////////////////////////
> option 1 .-
>
> select max(bi_num) as num
> from b_inmuebles
> where concat(nloc_num) = 1     and
>       concat(ins_numero)= 1770 and
>       concat(ins_digi)= 1
>
>
> return it 1
>
>
> /////////////////////////////////////////////////////////
> option 2 .-
>
> select max(bi_num) as num
> from b_inmuebles
> where nloc_num = 1     and
>       ins_numero= 1770 and
>       ins_digi= 1
>
> return it NULL
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to