You can use the REPLACE function.

UPDATE YourTable SET YourCol = REPLACE(YourCol,'''','')


--

Andrew J. Kelly
SQL Server MVP


"Dmitri Manushin" <dm-manmail.ru> wrote in message
news:uWrilShRDHA.1072TK2MSFTNGP10.phx.gbl...
> Hi all.
>
> I have a names contain symbol ' (example dimit'ri) how i can use sql
> delete this symbol?
>
>
> Tank you.
>
>