Subject Re: [firebird-support] Problem with where clause
Author Mark Rotteveel
On 5-1-2018 13:23, m_brahim11@... [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 Rotteveel