Re: concat() function

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

concat() function

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_inmueble