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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
adding the contents of a memo field to a report using SQL - SELECT
I know it looks convoluted. BETWEEN(val(trim(staff_list.office_no)),3,10)=.f. = .T. allows me to select the records that fall outside of the range 3-10 (in this case 445 records). BETWEEN(val(staff_list.office_no), 3, 10) selects the records that fall within the range (the 17 records I...- eldredn
- Post #8
- Forum: Microsoft: FoxPro
-
adding the contents of a memo field to a report using SQL - SELECT
That worked!!!! Thanks a lot. genius. eldredn@aquent.com- eldredn
- Post #7
- Forum: Microsoft: FoxPro
-
adding the contents of a memo field to a report using SQL - SELECT
Thanks for the quick response, foxdev. Unfortunately, "left(staff_list.notes,4)" didn't work. Again, only the first digit appeared in the report. I even tried saving it to a .csv instead of .xls and opening it in Word. The thing is, typing "? left(staff_list.notes,4)"...- eldredn
- Post #4
- Forum: Microsoft: FoxPro
-
adding the contents of a memo field to a report using SQL - SELECT
I want to export some data from 3 tables into an Excel spreadsheet. I've included the SELECT command below. Everything is fine except IT ONLY EXPORTS THE FIRST CHARACTER FROM THE staff_list.notes FIELD (which is a memo field with the phone extension). Note: I put the extensions in a memo...- eldredn
- Thread
- Replies: 8
- Forum: Microsoft: FoxPro
