Seattle just shook hard.
Anyway, I think you want the text concatenation operator, ||
You might need to cast the data to text also.
On Wed, 28 Feb 2001, Donald Braman wrote:
> I'm trying to update a column to it's orignal contents plus a space plus the
> contents of another column.
>
> UPDATE cases
> SET citation = citation + ' ' + text(year);
>
> (citation is text type and year is char type, hence the use of text()
> function)
> I get: Unable to identify an operator '+' for types 'text' and 'unknown'
> I can't find any documentation on how to this sort of thing, so any help is
> appreciated. -Don
>
--
James Eric Lawson
Research Publications Editor III
National Simulation Resource
eric@bioeng.washington.edu
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Everyday language is a part of the human organism and is no less
complicated than it. - Ludwig Wittgenstein (1889-1951) [Tractatus
Logico-Philosophicus, 1921]