Text and Image Functions

MSDN Library

MSDN Home MSDN Library MSDN Learn MSDN Downloads MSDN Support MSDN Community

Development Tools and Languages Mobile and Embedded Development .NET Development Office Development Servers and Enterprise Development Web Development Win32 and COM Development MSDN Library Archive

Servers and Enterprise Development

Enterprise Architecture, Patterns, ...Enterprise Management BizTalk Server Commerce Server Connected Services Framework Content Management Server Exchange Server Host Integration Server Industry Solutions Group Internet Security and Acceleration ...Microsoft Dynamics Microsoft Enterprise Search Microsoft MapPoint Microsoft Compute Cluster Server 20...Software Testing Speech Server SQL Server Synchronization Windows Home Server SDK Windows Server

SQL Server

SQL Server 2008 SQL Server 2005 SQL Server 2000 SQL Server 7.0

SQL Server 2000

SQL Server 2000 Books Online SQL Server 2000 (64-bit) Books Onli...SQL Server 2000 Notification Servic...SQL Server 2000 Reporting Services ...SQL Server 2000 Windows CE Edition ...SQLXML Technical Articles Columns Periodicals

SQL Server 2000 Books Online

Getting Started What's New Installing SQL Server SQL Server Architecture Administering SQL Server Creating and Maintaining Databases Creating and Using Data Warehouses Accessing and Changing Relational D...XML and Internet Support Transact-SQL Reference Optimizing Database Performance Replication Data Transformation Services Analysis Services English Query Meta Data Services Building SQL Server Applications Using the SQL Server Tools User Interface Reference Troubleshooting Glossary How To

Transact-SQL Reference

Transact-SQL Overview Transact-SQL Syntax Conventions New and Enhanced Features in Transa...+ (Add)+ (Positive)+ (String Concatenation)- (Negative)- (Subtract)* (Multiply)/ (Divide)% (Modulo)% (Wildcard - Character(s) to Match...& (Bitwise AND)| (Bitwise OR)^ (Bitwise Exclusive OR)~ (Bitwise NOT)= (Equals)> (Greater Than)< (Less Than)>= (Greater Than or Equal To)<= (Less Than or Equal To)<> (Not Equal To)!< (Not Less Than)!= (Not Equal To)!> (Not Greater Than)-- (Comment)/*...*/ (Comment)[ ] (Wildcard - Character(s) to Mat...[^] (Wildcard - Character(s) Not to..._ (Wildcard - Match One Character)@@CONNECTIONS @@CPU_BUSY @@CURSOR_ROWS @@DATEFIRST @@DBTS @@ERROR @@FETCH_STATUS @@IDENTITY @@IDLE @@IO_BUSY @@LANGID @@LANGUAGE @@LOCK_TIMEOUT @@MAX_CONNECTIONS @@MAX_PRECISION @@NESTLEVEL @@OPTIONS @@PACK_RECEIVED @@PACK_SENT @@PACKET_ERRORS @@PROCID @@REMSERVER @@ROWCOUNT @@SERVERNAME @@SERVICENAME @@SPID @@TEXTSIZE @@TIMETICKS @@TOTAL_ERRORS @@TOTAL_READ @@TOTAL_WRITE @@TRANCOUNT @@VERSION ABS ACOS ALL ALTER DATABASE ALTER FUNCTION ALTER PROCEDURE ALTER TABLE ALTER TRIGGER ALTER VIEW AND ANY APP_NAME ASCII ASIN ATAN ATN2 AVG BACKUP BEGIN...END BEGIN DISTRIBUTED TRANSACTION BEGIN TRANSACTION BETWEEN binary and varbinary BINARY_CHECKSUM bit BREAK BULK INSERT CASE CAST and CONVERT CEILING char and varchar CHAR CHARINDEX CHECKPOINT CHECKSUM CHECKSUM_AGG CLOSE COALESCE COLLATE COLLATIONPROPERTY COL_LENGTH COL_NAME COLUMNPROPERTY COMMIT TRANSACTION COMMIT WORK Constants CONTAINS CONTAINSTABLE CONTINUE Control-of-Flow Language COS COT COUNT COUNT_BIG CREATE DATABASE CREATE DEFAULT CREATE FUNCTION CREATE INDEX CREATE PROCEDURE CREATE RULE CREATE SCHEMA CREATE STATISTICS CREATE TABLE CREATE TRIGGER CREATE VIEW CURRENT_TIMESTAMP CURRENT_USER cursor CURSOR_STATUS Cursors DATABASEPROPERTY DATABASEPROPERTYEX Data Types DATALENGTH DATEADD DATEDIFF DATENAME DATEPART datetime and smalldatetime DAY DB_ID DB_NAME DBCC DEALLOCATE decimal and numeric DECLARE @local_variable DECLARE CURSOR DEGREES DELETE DENY DIFFERENCE DROP DATABASE DROP DEFAULT DROP FUNCTION DROP INDEX DROP PROCEDURE DROP RULE DROP STATISTICS DROP TABLE DROP TRIGGER DROP VIEW DUMP ELSE (IF...ELSE)END (BEGIN...END)EXECUTE EXISTS EXP Expressions FETCH FILE_ID FILE_NAME FILEGROUP_ID FILEGROUP_NAME FILEGROUPPROPERTY FILEPROPERTY float and real FLOOR fn_get_sql fn_helpcollations fn_listextendedproperty fn_servershareddrives fn_trace_geteventinfo fn_trace_getfilterinfo fn_trace_getinfo fn_trace_gettable fn_virtualfilestats fn_virtualservernodes FORMATMESSAGE FREETEXT FREETEXTTABLE FROM FULLTEXTCATALOGPROPERTY FULLTEXTSERVICEPROPERTY Functions GETANSINULL GETDATE GETUTCDATE GO GOTO GRANT GROUP BY GROUPING HAS_DBACCESS HAVING HOST_ID HOST_NAME IDENT_CURRENT IDENT_INCR IDENT_SEED IDENTITY (Property)IDENTITY (Function)IF...ELSE image IN INDEXKEY_PROPERTY INDEXPROPERTY INDEX_COL Information Schema Views INSERT int, bigint, smallint, and tinyint IS_MEMBER IS_SRVROLEMEMBER ISDATE IS [NOT] NULL ISNULL ISNUMERIC KILL LEFT LEN LIKE LOAD LOG LOG10 LOWER LTRIM MAX MIN money and smallmoney MONTH NCHAR nchar and nvarchar NEWID Northwind Sample Database NOT ntext, text, and image NULLIF numeric OBJECT_ID OBJECT_NAME OBJECTPROPERTY OPEN OPENDATASOURCE OPENQUERY OPENROWSET OPENXML Operators OR ORDER BY PARSENAME PATINDEX PERMISSIONS PI POWER Predicate PRINT pubs Sample Database QUOTENAME RADIANS RAISERROR RAND READTEXT real RECONFIGURE REPLACE REPLICATE Reserved Keywords RESTORE RESTORE FILELISTONLY RESTORE HEADERONLY RESTORE LABELONLY RESTORE VERIFYONLY RETURN REVERSE REVOKE RIGHT ROLLBACK TRANSACTION ROLLBACK WORK ROUND ROWCOUNT_BIG RTRIM SAVE TRANSACTION SCOPE_IDENTITY Search Condition SELECT @local_variable SELECT SERVERPROPERTY SESSION_USER SESSIONPROPERTY SET @local_variable SET SETUSER SHUTDOWN SIGN SIN smalldatetime smallint smallmoney SOME | ANY SOUNDEX SPACE sql_variant SQL_VARIANT_PROPERTY SQUARE SQRT STATS_DATE STDEV STDEVP STR STUFF SUBSTRING SUM SUSER_ID SUSER_NAME SUSER_SID SUSER_SNAME System Stored Procedures System Tables SYSTEM_USER table TAN text TEXTPTR TEXTVALID timestamp tinyint Trace Flags Transactions TRIGGER_NESTLEVEL TRUNCATE TABLE TYPEPROPERTY UNICODE UNION uniqueidentifier UPDATE UPDATE STATISTICS UPDATETEXT UPPER USE USER USER_ID USER_NAME VAR varbinary varchar VARP WAITFOR WHERE WHILE WRITETEXT YEAR

Functions

Aggregate Functions Configuration Functions Cursor Functions Date and Time Functions Mathematical Functions Meta Data Functions Rowset Functions Security Functions String Functions System Functions System Statistical Functions Text and Image Functions

Text and Image Functions

Transact-SQL Reference (SQL Server 2000)

Text and Image Functions

These scalar functions perform an operation on a text or image input value or column and return information about the value.

PATINDEX

TEXTPTR

TEXTVALID

These text and image functions are nondeterministic functions and they may not return the same results each time they are called, even with the same set of input values. For more information about function determinism, see Deterministic and Nondeterministic Functions.

Product Families

Resources

About Microsoft

Popular Places

Popular Searches

Popular Downloads

SQL Server Developer Center

See Also