> I understand the 'there is more than one operator' errors, but> what is so different between operators + and || ?
?? They are different operators, that's why. The "+" is addition, andthe "||" is defined in SQL92 to be string concatenation.
- Tom