How to query for a specific part of a string field with SQL?

Is it possible to build a query/SELECT-Statement with SQL like that:

SELECT name
FROM MyTable
WHERE name[2] = 'x'