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]
