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]