How can we find the middle character of any name using LIKE command in sql

Question

Please answer with code

Answer 1

But It will retrieve the value having x at any position