I
ifoundgoldbug
i have 3 types of location that i need to get rid of at the beginning
of a string they are listed like this.
they are ALWAYS in the following format where it is plus a space
deleted Battle Angel Alita
on cd Azumanga Daioh
on hdd Appleseed (2004)
what i would like is have the location data moved from [series][title]
to [location][location] i am unsure on how to go about writing the
update statement on this I THINK that it can be done with IIF but i am
not very good with sql.
thank you so much for your time
of a string they are listed like this.
they are ALWAYS in the following format where it is plus a space
deleted Battle Angel Alita
on cd Azumanga Daioh
on hdd Appleseed (2004)
what i would like is have the location data moved from [series][title]
to [location][location] i am unsure on how to go about writing the
update statement on this I THINK that it can be done with IIF but i am
not very good with sql.
thank you so much for your time