I got the following to work under Universe 10.0.16- LIST VOC WITH F1 LIKE '0X"0X'
Hope that helps Rod Hills -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Keith Johnson Sent: Thursday, October 27, 2005 12:21 PM To: [email protected] Subject: RE: [U2] [UD] how to find records with a " in the data Please post; I would like this information too. -Keith Johnson LCSC. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kathy Tymoczko Sent: Wednesday, October 26, 2005 2:09 PM To: [email protected] Subject: [U2] [UD] how to find records with a " in the data We have a number of records with double-quote (") characters in one of the data fields. We'd like to be able to select those records so we can fix up the data. Is there any way to find these records with a SELECT statement? I've tried: SELECT filename WITH fieldname LIKE '..."...' which gives a "missing quote" error and SELECT filename WITH fieldname LIKE ..."... which returns all the records in the file ESEARCH does work, but we thought we should be able to do this somehow with SELECT. Kathy Tymoczko Information Technology Services Wabash College, Crawfordsville, Indiana 47933 [EMAIL PROTECTED] 765-361-6440 ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
