Hi,
I have a table like this:

id | name
+++++++++
1 | ab
2 | bq
3 | g
4 | qaa
5 | e

I'd like to add "11" after the last character for each row in a column. So I need it to be:

id | name
+++++++++
1 | ab11
2 | bq11
3 | g11
4 | qaa11
5 | e11

I tried: "UPDATE table SET name=name+'11' , but that doesnt work.

Is there a way to accomplish this?