ChampionDuy
Registered User.
- Local time
- Today, 08:21
- Joined
- Mar 14, 2002
- Messages
- 94
I just cant seem to get my update query to correctly update my field. I have a field called Case_No in a table called REVIEW. The case_no field is currently in this format 00-000. Where the first two digits are the current calander year and the last 3 are just a number that starts at 001 and goes up to 999 every time a new case is added. Well you guessed it I have reached my maximum case number for 2004. I am currently stuck at 04-999.
How can I update all my rows so that 04-999 will change to 04-0999, and 01-300 will change to 01-0300.
Any help would be appreciated, thank you very much.
How can I update all my rows so that 04-999 will change to 04-0999, and 01-300 will change to 01-0300.
Any help would be appreciated, thank you very much.