If this is a one time deal, why use *? If you already know the columns, you can simply add a case statement to the field you want to hard code.

Another approach would be to use select * into your target table, then use an update on that table:

UPDATE myTable, SET myField = 'MY HARD CODED VALUE' WHERE myField = myCondition