Updating multiple records 1

[mevasquez]

I have a database containing thousands of records and I need to update a portion of a column. For Example, a column might have HSL41, HSL42, HSL5. etc. I want to be able to update the "HSL" to "HSM".

Is there a way to update all these records at one time without having to update these one at a time. Each of the data above in the specific column might contain 25,000 records.

TIA

Mike

 

[PHV]

Something like this (SQL code) ?
UPDATE yourTable
SET yourColumn = 'HSM' & Mid(yourColumn,4)
WHERE yourColumn Like 'HSL*'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886