ArcObjects Library Reference (GeoDatabase)  

ISQLSyntax.GetSpecialCharacter Method

Special DBMS dependent SQL characters.

[Visual Basic .NET]
Public Function GetSpecialCharacter ( _
    ByVal sqlSC As esriSQLSpecialCharacters _
) As String
[C#]
public string GetSpecialCharacter (
    esriSQLSpecialCharacters sqlSC
);
[C++]
HRESULT GetSpecialCharacter(
  esriSQLSpecialCharacters sqlSC,
  BSTR* pSpecialChar
);
[C++]

Parameters

sqlSC [in]

  sqlSC is a parameter of type esriSQLSpecialCharacters

pSpecialChar [out, retval]   pSpecialChar is a parameter of type BSTR

Product Availability

Available with ArcGIS Engine, ArcGIS Desktop, and ArcGIS Server.

Description

GetSpecialCharacter returns a String value that indicates which character is used to represent the esriSQLSpecialCharacters value specified.

Remarks

The GetSpecialCharacter can be used to return the DBMS dependent character that represents an SQL special character, including the following:

esriSQL_WildcardManyMatch ( % in SQL_92, * in Jet 4.0)
esriSQL_WildcardSingleMatch ( _ in SQL_92, ? in Jet 4.0)
esriSQL_DelimitedIdentifierPrefix ( " in SQL_92, [ in Jet 4.0)
esriSQL_DelimitedIdentifierSuffix (" in SQL_92, ] in Jet 4.0)

See Also

ISQLSyntax Interface