Adding substring to fields

[MatsHulten]

I need to do an update to certain stringfields in a table, preserving the old values and inserting a substring first.
I.e Old value: 'Anna Olsson', new value 'SE-Anna Olsson'.

The string 'SE-' would be a constant string to be insrted in all of the matching fields.

Any helpful suggestions to how I can do this witout having to export the table into a recordset and modify it outside SQL.

-Mats

 

[foxdev]

Try something like this:

[tt]update mytable
set mycolumn = 'SE' + mycolumn [/tt]
Robert Bradley

http://www.foxdev.com/

http://www.agrainofhope.org

 

[MatsHulten]

That did the trick!
Thanx a lot!

-M