CAllDatabase::Substr

public function Substr($str, $from, $length = null)
{
	// works for mysql and oracle, redefined for mssql
	$sql = 'SUBSTR('.$str.', '.$from;

	if (!is_null($length))
	{
		$sql .= ', '.$length;
	}

	return $sql.')';
}