How to escape parenthesis in SQL query?

Question

Hello,

Using Microsoft SQL Server 2005 - wondering how can I escape parenthesis in my query?

I'm trying to find the string position of "(" in one of my columns returned, but Management Studio keeps thinking I'm opening another command when I use that. I've tried \ but that isn't escaping it.

Thank you!

Answer 1

this doesn't work for you?

select charindex('(', yourColumn)
from yourTable

Answer 2

You don't need to escape it, see example below:

select charindex('(', x)
from (
    select 'asdasda(adsadas' as x
) a

Output:

8

Answer 3

select charindex('(',<columnname>) from <tableName>