sqlIdentifierPrepareForCompare

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 (&lt;part1&gt;."&lt;part2&gt;" for example)

string
sqlIdentifierPrepareForCompare
(
string str
)

Parameters

str string

a quoted string

Return Value

Type: string

str