On 5-1-2018 13:23, m_brahi...@yahoo.fr [firebird-support] wrote: > Thanks but adding a quote at the end doesn't work. In fact adding double > quote because with one the SP will not be compiled
That is because || '; would open a string but not end it, then ||''; doesn't work, because that is just an empty string. You'd need ||'''';, as '' is how you escape a single quote in a string literal. But as I answered elsewhere, this isn't the right solution for your problem. Mark -- Mark Rotteveel