Why do I get the error "Invalid operator for data type. Operator equals add, type equals text."
when trying to append to my field (varchar)?
SET note = note + 'some text here'
from notes h INNER JOIN phones p on h.[number] = p.[number]
where (p.gpi is null or p.gpi = 1)