Simple SELECT’s—continued

• Use expressions and native functions

• FNm + ‘ ‘ + LNm + ‘ was born on ‘ + Format(DOB,’mmm d, yyyy’)

• ORDER BY DOB DESC

• Off-load work to the database engine

• There are CF, ODBC and native engine functions;Do you know where your work is being done?

Previous slide

Next slide

Back to first slide

View graphic version