I want ends with so you don't use the trailing ellipses just ...DOG The LIKE can take single or double quotes without care (that's in the documentation) You missed the point of my message which was that putting the ellipses outside the quotes makes the statement fail. That's why it fails, not because of the quote type. Try it with double quotes. I bet it still fails if the ellipses is outside the quotes.
-----Original Message----- From: Jeff Schasny <jscha...@gmail.com> To: U2 Users List <u2-users@listserver.u2ug.org> Sent: Fri, Sep 2, 2011 12:28 pm Subject: Re: [U2] List Voc Like .... LIST VOC WITH @ID LIKE ...DOG... no quotes, especially not single quotes which woulf indicate an explicit ecord ID Wjhonson wrote: LIST VOC LIKE ...'DOG' fails, listing everything LIST VOC LIKE '...DOG' passes, listing just those items ending in DOG The online HELP documentation gives no examples of using the quotes, they just tate it without an example. Or rather the example is just the 'string' by itself without it's use in ontext of the ... _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- ----------------------------------------------------------------------- eff Schasny - Denver, Co, USA schasny at gmail dot com ----------------------------------------------------------------------- ______________________________________________ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users