A admin Administrator Staff member Aug 21, 2008 #1 I have a table that has a field "Category" and I want to set all records that have category 'X' to have category 'Y' also. What SQL statement can I use to do this in on fell swoop?? Hardly a perfect database but this is what I have to work with
I have a table that has a field "Category" and I want to set all records that have category 'X' to have category 'Y' also. What SQL statement can I use to do this in on fell swoop?? Hardly a perfect database but this is what I have to work with
