larry a price writes: > SELECT table1.name,table2.web,table2.email > WHERE table1.name LIKE upper(table2.name).'%'; > ^^^^^^ trying for > 'content%' || is the operator for string concatenation. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
