Add user profiles and update all to YES ???

[Lynne]

Could just run this (change table name if you have a prefix):

UPDATE userfield SET field6='Yes';

And, as always, backup your database before running any query on it!!!

[Scalemotorcars]

Sorry I dont follow. As in VB prefix. I use a custom value. So basically it would look something like this?

UPDATE vb123_userfield SET fieldXX='Yes';

[Lynne]

If your vb prefix is "vb123_", then yes, that is what it would look like.

[Scalemotorcars]

Thanks again Lynne, time to do a backup and give it a shot.