QuoteSQL

[Lawrence D'Oliveiro]

In message <slrnehfah2.foq.sybrenUSE at schuimige.stuvel.eu>, Sybren Stuvel
wrote:

> Duncan Booth enlightened us with:
>> I think his point was that any '%' characters inside name act like
>> wildcards whereas his version looked for literal percents.
> 
> But of course.
> 
>> This could be an argument for having a utility function to escape
>> the wildcards for this sort of situation, but certainly not an
>> argument for his proposed QuoteSQL.
> 
> Indeed. An escaping function should be small and not do all kinds of
> escaping for different situations at once.

Look at it this way: there is _no_ case where you need escaping of wildcards
without also escaping other specials.