sqlIdentifierPrepareForCompare

fnstring sqlIdentifierPrepareForCompare(string str)

Prepares str to be compared:

<itemizedlist> <listitem><para>if surrounded by double quotes or single quotes, then just remove the quotes</para></listitem> <listitem><para>otherwise convert to lower case</para></listitem> </itemizedlist>

The quoted string:

<itemizedlist> <listitem><para>must start and finish with the same single or double quotes character</para></listitem> <listitem><para>can contain the delimiter character (the single or double quotes) in the string if every instance

of it is preceeded with a backslash character or with the delimiter character itself</para></listitem>

</itemizedlist>

This function is normally used only by database provider's implementation.

WARNING: str must NOT be a composed identifier (<part1>."<part2>" for example)

Parameters

stra quoted string

Returns

str