ArcObjects Library Reference (GeoDatabase)  

ISQLSyntax.GetSpecialCharacter Method

Special DBMS dependent SQL characters.

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


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.


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


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