UPDATE using LIKE?

is it possible to update a set of records that require wildcards to select? for example, i would like to update the records returned from the following select statement:

        select name from brian.table where name like 'A__B%'

i would like to change the 'A' to a 'B'. the update command does not appreciate the 'like' command. i'd prefer to do this in a single query. thanks.

-brian

--

________ ________ .__    ___    _____      _______________.__    .__   ____.__.
\____   \\____   \|  |  / _ \   \Brian J Gelly__/\_ _____/|  |   |  |  \__ |  |
 |  |  _/ |     _/|  | / / gelly_at_garfld.cle.ab.com \ __)_ |  |   |  |   /  |  |
 |  |   \ |  |   \|  |/  bu921_at_cleveland.freenet.edu     \|  |__ |  |__ \__   |
 |____  / |__|_  /|Allen-Bradley_Co., Inc.\-_Cleveland, Ohio!__ \|____ \/ ____|
      \/       \/           \/       \/        \/      \/      \/     \/\/