update as command syntax has changed