Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Adding substring to fields

Status
Not open for further replies.

MatsHulten

Programmer
Joined
Dec 29, 2000
Messages
180
Location
SE
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
 
That did the trick!
Thanx a lot!

-M
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top