T-SQL Functions

The T-SQL language contains numerous functions that you can incorporate into the T-SQL statements that you build. These functions perform a variety of important tasks. The text that follows covers some of the commonly used numeric, string, date/time, and null-related functions. For additional information on the plethora of T-SQL functions available, consult Books On-line.

Numeric Functions

Important numeric functions include IsNumeric and ROUND. The sections that follow example these functions and provide examples of their uses.

The IsNumeric Function

The IsNumeric function returns information on whether a value is numeric. Here's an example:

SELECT CustomerID, PostalCode, IsNumeric(PostalCode) FROM Customers
							

The SELECT statement ...

Get Alison Balter's Mastering Access 2002 Enterprise Development now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.