how do i write an update query that will iterate through all rows and change all the names in the database to reflect the first letter of their names e.g name like vernon should now appear as v after the update [ January 21, 2005: Message edited by: Bear Bibeault ]