Strip Out Data from Field 1

[sila]

Hi
I hope someone can help me with this problem.

In the query below there may be some ForeName1 fields where there is a name e.g. Joseph (Joe). How can I use the query to strip out any instances where there is a name in brackets and leave the main name only as I need to put this into a url?

Thanks

<code>
(@MemberID as integer)
AS
SELECT ForeName1 + '_ ' + Surname AS Name FROM dbo.Members
WHERE MemberID = @MemberID
RETURN
</code>

 

[JamesLean]

Easiest way would be to just take the characters up to the opening parenthesis:

SELECT LTRIM(RTRIM(CASE WHEN forename1 LIKE '%(%' THEN LEFT(forename1, CHARINDEX('(', forename1) - 1) ELSE forename1 END)) + '_' + surname AS name
FROM members

--James

 

[hmckillop]

Alternatively

select 
CASE WHEN charindex('(', forename1) > 0 THEN rtrim(left(forename1, charindex('(', forename1)-1)) 
	ELSE rtrim(forename1)
END as Forename1
from @members

"I'm living so far beyond my income that we may almost be said to be living apart

 

[sila]

Thanks that worked a treat.