Re: a query with = ALL

>"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