>"Jaime Casanova" <el_vigia_ec@hotmail.com> writes:
>>brings 'A ', 'B ', 'C ' well when i cHange the real query
>Given that you spelled it like that, I wonder whether you aren't
>confused about the behavior of cross-data-type comparisons. If
>one column is char(n) and the other is text or varchar(n) then you
>may get results you didn't expect. These types have different ideas
>about whether trailing blanks are significant or not.
both CPA.cur_paralelo and the cur_paralelo obtained in the subquery are
char(2) i assume there are no problem, i'm wrong?
thanx in advance,
Jaime Casanova
_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
http://join.msn.com/?page=features/virus