In the attached file, the lines 4 and 6 have the same structure, the line 4 changes the value of {a} properly, the line 6 didn't.

Thank you.

Please provide your example as a text.

```
a = "some_underscored_value"


u = (f" hello `{a}` cruel world"
     " hi")

print(u)

query = (f"SELECT COUNT(*) "
         "FROM `{a}` entry "
         "WHERE entry.type == 'device' "
         "AND entry.instance == {a}")

print(query)
```

What you get? What you expect?

I got:

SELECT COUNT(*) FROM `{a}` entry WHERE entry.type == 'device' AND entry.instance == {a}

I expect the value of `{a}` changed, like:

SELECT COUNT(*) FROM `some_underscored_value` entry WHERE entry.type == 'device' AND entry.instance == some_underscored_value

The expression is a concatenation of f-string expression f"SELECT COUNT(*) " and three string literals. If you want to substitute the "a" value, convert string literals into f-string expressions:

query = (f"SELECT COUNT(*) "
         f"FROM `{a}` entry "
         f"WHERE entry.type == 'device' "
         f"AND entry.instance == {a}")

or

query = ("SELECT COUNT(*) "
         f"FROM `{a}` entry "
         "WHERE entry.type == 'device' "
         f"AND entry.instance == {a}")

But be aware that using f-string expressions for formatting SQL queries is not safe in general case. Instead, use the DB-API’s parameter substitution.

Serhiy Storchaka,

Thank you for your explanation.