I am trying to select records in Base to a CSV. I have tried this statement and it works:
SELECT * INTO [Text;HDR=NO;Format=CSVDelimited;DATABASE=C:\].MyTable.CSV FROM `License Survey Response Code Table (Public)`; But that is all records. I want a subset using a LIKE statement. I've tried: SELECT * FROM "License Survey Response Code Table (Public)" WHERE "Survey Response Code" LIKE '04%') INTO [Text;HDR=NO;Format=CSVDelimited;DATABASE=C:\].MyTable.CSV; No Luck. Is my syntax wrong? -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
