SQL Query to fill a field with a number based on another field
I have a "SortOrder" field that I need to populate with a number (1, 2, 3, etc), based on the name in a ProductBrand field. I would like to expedite it by writing a sql query and could use some help.
So: If "ProductBrand" is XXXX, "SortOrder" is "1".
Thanks