- Code: Select all Expand view
- (domicilio )+Alltrim (piso )+Alltrim (depto )
a Index Expression must be "same Length" so ALLTRIM() are NOT working "in" a Index
---
it seem me that your YEAR use only 2 Digit ?
than try
- Code: Select all Expand view
- SET EPOCHE TO YEAR(DATE()) -50