Question: I want to put a condition in my query where I have a column that should contain second position as an alphabet.

How to achieve this?

I've tried with `_[A-Z]%` in where clause but is not working. I've also tried `[A-Z]%`.

Any inputs please?

Answer: 
I think you want mysql query. like this

```
SELECT * FROM table WHERE column REGEXP '^.[A-Za-z]+$'

```

or sql server

```
select * from table  where  column like '_[a-zA-Z]%'

```
The use of `'%[A-Z]%'` suggests that you are using SQL Server. If so, you can do this using `LIKE`:

```
where col like '_[A-Z]%'

```

For `LIKE` patterns, `_` represents any character. If the first character needs to be a digit:

```
where col like '[0-9][A-Z]%'

```

EDIT:

The above doesn't work in DB2. Instead:

```
where substr(col, 2, 1) between 'A' and 'Z'

```