What is the best format for this select condtion?

[ucu13]

i have a 'Like' condition in Sql Server Select query

My condition is this:

WHERE IntestazioneCompleta LIKE '%D'AZEGLIO%'

if i have a simple word like 'AZEGLIO' all works fine

but with this type of word 'D'AZEGLIO'

how i can format this in sql to make it work with this type of words?
thanks in advance..

[ucu13]

solved!!!

WHERE IntestazioneCompleta LIKE '%D%AZEGLIO%'

in php i used this code:

$string=D'AZEGLIO;

$string= preg_replace('/(\w)\'(\w)/', '$1%$2', $string);