Mark student emails as home and primary

[ozydave]

I have got all of my students email addresses into sims (section 4) of student details.

 

Some are marked as marked "primary", some "home and primary" and some just "home"

 

Anyone got a quick method to mark them all as "home and primary" maybe and SQL method?

 

Cheers

[ozydave]

OK sorted it

 

SQL management, then this simple query

 

UPDATE [sims].[sims].[sims_email]

SET main='T'

Where email_address like '%@domain.com ' and main ='F'

 

Cheers