Query to get specific word in a column

[JayaDurai]

Hi, I am need of a query to retrieve a column by trimming in a particular format. For example I have a field called UserName. The data is as follows UserName -------- user1 (user1@noreply.com) user2 (user2@noreply.com) user3 (user3@noreply.com) Here I want a query to retrieve username data as user1 user2 user3 I have to trim the content from '(' to ')' Please Let me know the query. Thanks in Advance, Jaya

[miah alom]

select substring(UserName,charindex('(',UserName), charindex(')',UserName)-charindex('(',UserName)) from UserTable is the sybase syntax. The SQL Server syntax should be equivalent. Please check.

[JayaDurai]

Hi alam, Thank you. I tried your query. Its working fine. The Query can be written as follows. select LEFT(UserName,CHARINDEX('(',UserName)-1) FROM UserTable Regards, Jaya

[under2811]

Hi!!!!!!! SELECT LEFT(USERNAME,PATINDEX('%(%',USERNAME)-1) Enjoy!!!! Regards Shashank