Hello.
> *nloc_num,ins_numero and ins_digi are decimal(3,0)
You're using 1770 for comparison which is not in the type range.
In my opinion, for incorrect data you may obtain incorrect answers.
Luciano Centeno wrote:
> 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) =3D 1 and
> concat(ins_numero)=3D 1770 and
> concat(ins_digi)=3D 1
>
>
> return it 1
>
>
> /////////////////////////////////////////////////////////
> option 2 .-
>
> select max(bi_num) as num
> from b_inmuebles
> where nloc_num =3D 1 and
> ins_numero=3D 1770 and
> ins_digi=3D 1
>
> return it NULL
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
