CiviCRM Community Forums (archive)

Background: Our organization has a significant number of members who are police officers and so want to include their rank prefix in some correspondance. Unfortunately, we realized too late that we didn't want to include it in the individual's prefix field but instead in a custom alphanumeric field called "rank". I've set up the new field, where the value is the appropriate prefix ("Sgt.") and the label is "Sergeant", but am hoping someone can help me craft an appropriate SQL statement to move certain prefixes over. (But not all the prefixes, because Mr/Ms/Mrs/Dr/Hon/etc should stay where they are...

So, a few questions:

1) What's the best way to set up this "rank" field? The way I did it, or as a numeric field with an associated option group that keeps the same option IDs? It'll only have a limited number of unique ranks in it.

2) I'm hardly lazy, but recognize that someone out there could probably craft an appropriate sql "update" statement to do the transfer quick-like-bunny, while figuring out the syntax myself would take me all day. Anyone able to help me?

Thanks in advance!

Chris.

What information could I provide, specifically, in case someone could write a SQL update query for me? I'm not above bribery or begging... heh.