Replace single quotes?

I tried the following and get an error:

$replace(%genre%,',#39;)

[ SYNTAX ERROR IN FORMATTING STRING ]

I also tried to escape the single quote, but get the same error:

$replace(%genre%,\',#39;)

am i missing something?

Cheers,
Drew

Write two single quotes.

Thanks Dano, that worked. I think I must be tired, that's a rookie mistake :wink: