O'Reilly logo

Alison Balter's Mastering Access 2002 Enterprise Development by Alison Balter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required