Best method to populate new datacard variable from existing

Created a new datacard variable for Solidworks files - I would like to do a batch process to populate this new variable (where blank) with the value of an existing variable.  What is the best method to do this?

I am thinking that this would have to be a sql statement update.  Does anyone have a similar problem and solution?

Thanks,

Jake

SolidworksSolidworks Pdm enterprise Pdm