Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: EarlStaley
- Order by date
-
What Type of Table
I use Database Desktop to create my tables. I have the option of creating the following types of tables: Paradox (various versions) dBase (various versions) FOXPRO INTRBASE MSACCESS When I use a SQL CREATE TABLE statement, what type of table is created? Thank You... Earl Staley- EarlStaley
- Thread
- Replies: 1
- Forum: ANSI_SQL
-
EXTRACT in ORDER BY
JarlH, I had already tried your suggestion and that didn't work either. The only place an EXTRACT statement works in my implementation is in a WHERE clause. For example: "SELECT * FROM FSBC_Member WHERE EXTRACT(MONTH FROM BirthDate)=1 ORDER BY LastName, FirstName" That is the only place I...- EarlStaley
- Post #3
- Forum: ANSI_SQL
-
EXTRACT in ORDER BY
I have a table for our membership with a Date field for birthdays. I am trying to get a list of the birthdays ordered by month and date. My first attempt to get the list used this SQL: "SELECT * FROM FSBC_Member WHERE BirthDate IS NOT NULL ORDER BY BirthDate,LastName,FirstName" This...- EarlStaley
- Thread
- Replies: 2
- Forum: ANSI_SQL
