[SQL] help

[Nicholas I]

Hi,

I have a table in which the data's are entered like,

Example:

One (1)
Two (2)
Three (3)

I want to extract the data which is only within the parentheses.

that is
1
2
3


Thank You
Nicholas I