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>
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>