"Jaime Casanova" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
