Re: UPDATE query question.
- The "+" was the ticket I was looking for. New language, new
concatenation symbol. Thanks.
--- In SQLQueriesNoCode@yahoogroups.com, "Razvan Socol" <rsocol@f...>
> It would be very useful if you could tell us which platform you use.
> In SQL Server (and maybe Oracle, too) this should work:
> UPDATE myTable SET field3 = field1 + ' ' + field2
> ----- Original Message -----
> From: Troy
> To: SQLQueriesNoCode@yahoogroups.com
> Sent: Friday, February 25, 2005 11:46 PM
> Subject: [SQLQueriesNoCode] UPDATE query question.
> I'm attempting to take the contents of field1 and field2 and put them
> into field3 (with 10 spaces between the fields) by way of an UPDATE
> query. For instance, field1 = "Homer" and field2 = "Simpson". When the
> query's run, field3 should equal "Homer Simpson".
> This doesn't work...
> UPDATE myTable SET field3 = field1 & " " & field2
> Can anyone give me a clue here as to the easy way to accomplish this