SQL Help

[Deane Venske]

Hi All,

I'd like to do a little more in my SQL statements than I am currently able.
Using other RDBMS I've been able to do a query like this :
UPDATE class SET name = "Class " & classID

This would do the following
BEFORE QUERY

`class` Table
+----------+----------+
| classID  | Name     |
+----------+----------+
| 1        |          |
| 2        |          |
| 3        |          |
| 4        |          |
+----------+----------+

AFTER QUERY

`class` Table
+----------+----------+
| classID  | Name     |
+----------+----------+
| 1        | Class 1  |
| 2        | Class 2  |
| 3        | Class 3  |
| 4        | Class 4  |
+----------+----------+

Can this be done in Valentina? I've tried doing
`UPDATE class SET name = concat("Class " & classID)`
As well as other variations. Can't get concat to work in updates even if
joinging two strings.

Regards,
Deane Venske