I have a query where I select data from a table using TSQL. When one of the fields (field1) has a certain value, I want to change the value of two other fields (field2 and field3) to NULL depending on the value of field1. I've browsed stack overflow and see many answers saying to UPDATE the table like this:

```sql
UPDATE MyTable
SET MyField = NULL
WHERE MyField = ''

```

But Update changes a table, right? I don't want to change my table data. I want to change my query results. Is there a way to change results of a query like I want?