Re: update questsion

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]