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 wOOdy-Soft 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: holdemfoldem
- Content: Threads
- Order by date
-
Ordering using poorly formatted column data...
...I'm writing an app in VB 6 connecting to a main frame DB2 data base and wish to order the results of a select statement by two fields, SCHLYEAR and TERM, corresponding to the school year and the term, (ie: Fall, Spring, or Summer). What keeps me from simply using: "SELECT FIELD1, FIELD2...- holdemfoldem
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
-
Determining the .dbf file version
I am working with some .dbf files and my supervisor wants to know what version they are. Presumably they're dBase IV, but is there some sort of utility I can run which will open the files and determine what version of dBase they represent? Thanks ahead for help!- holdemfoldem
- Thread
- Replies: 5
- Forum: dBASE Inc.: dBASE
-
I need something similar to "Sum()" but for strings.
To get the sum of a given column for a group of rows sharing the same column value, you do the following: SELECT ccustno, sum(nbalance) as totalbalance FROM arinvc GROUP BY ccustno My question: How do you concatenate the string values of a given column for a group of rows? I...- holdemfoldem
- Thread
- Replies: 15
- Forum: Microsoft SQL Server: Programming
