getsubstring-method-sqlserverclob.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	apilocation	apiname	apitype
getSubString Method (SQLServerClob)	getSubString Method (SQLServerClob)	David-Engel	davidengel	01/19/2017	sql	connectivity	reference	sqljdbc.jar	SQLServerClob.getSubString	Assembly

getSubString Method (SQLServerClob)

[!INCLUDEDriver_JDBC_Download]

Returns a copy of the specified substring in the CLOB based on the given starting position and the number of characters to copy.

Syntax

  
public java.lang.String getSubString(long pos,  
                                     int length)  

Parameters

pos

The first character of the substring to be extracted. The first character is at position 1.

length

The number of consecutive characters to be copied.

Return Value

A String that is the specified substring in the CLOB.

Exceptions

SQLServerException

Remarks

This getSubString method is specified by the getSubString method in the java.sql.Clob interface.

Trying to get zero characters from a null or zero-length CLOB returns an empty string. Trying to get any length of characters at any position other than position 1 in a zero-length CLOB will cause a position exception to be thrown.

See Also

SQLServerClob Methods
SQLServerClob Members
SQLServerClob Class