Replace A Caracter Like Apostrophe

Hai,

In my datedabase I have some customers with the next name: 't Woud.

The problem is the apostrophe in my query for my drill through.

This is my query:

SELECT DISTINCT c.alias AS Client, p.Alias AS Periode, u.alias as Product, v.alias as Verschil, CAST(s.indicatie AS decimal(6, 2)) AS Indicatie, CAST(s.realisatie AS decimal(6, 2)) AS Realisatie, CAST(s.real_indic AS decimal(6, 2)) AS [Realisatie -/- Indicatie], CAST(s.indicatie_fin AS decimal(6,0)) AS [Indicatie Fin], CAST(s.realisatie_fin AS decimal(6,0)) AS [Realisatie Fin], CAST(s.real_indic_fin AS decimal(6,0)) AS [Realisatie -/- Indicatie Fin]
FROM [BI_TZR].dbo.fact_clientsignaal s INNER JOIN
[BI_TZR].dbo.dim_verschil v ON s.verschil = v.verschil INNER JOIN
[BI_TZR].dbo.Dim_Periodewk p ON s.periode = p.Periode INNER JOIN
[BI_TZR].dbo.dim_client_uren c ON s.client_id = c.id INNER JOIN
[BI_TZR].dbo.dim_product u ON s.product = u.product
WHERE (LEFT(p.Alias, 1) = 'p') AND (c.alias like '%794735%') and s.kplts <> '1583'
ORDER BY s.product, s.periode

I try this:
SELECT DISTINCT replace ( c.alias, 'd', '') AS Client, this works, for the caracter D. But know I want it for the caracter apostrophe.

Can someone help me??

TNX