Convert String to Array

I have one scenario to be change existing string variable to List of string.

For example:
“empName” : “Shiva” - This need to change to “empName” : [“Shiva”]

I need to run it in our production database. I would like to know your suggestions any option to run query or any simple steps to do this change directly in database?

Thanks in advance for your answers.