Trim data and separate into two
Posted on 2005-04-27
hi every body.
i have the ff: table .
title Volume issue
Supersonic 1-2 1-2
title Volume Volstart VolEnd IssStart IssEnd
Supersonic 1-2 1 2 1 2
I want to populate the volume data before the dash as Volstart and the data after the dash as volend, same goes with Issue field. though if the data has no '-' (dash), the query s/b able to populate same data to VolStart and VolEnd. How should i update the table in a single query?