Mass Replacing of text from 1 field to another

[weeevil]

Hi all,

I have an SQL database, and i am trying to make a statement that checks if a field is not empty, and if it is empty, it puts in what is in another field.

They are both text fields, i've been scouring the net for if then statements, but im sure it's something more than a simple if then statement.

Thanks!

[joelgreen]

update tablename set city1 = city2 where city1 = ''

[weeevil]

thanks a lot, worked a treat