Colon (:) as literal in a construt statement

Posted in 2010

Long Nguyen — Wed, 29 Dec 2010 03:49:48 — source: IIUG Forums & Mailing Lists

Hi all, Is there anyway to make the construct statement use the input colon (:) as it is, instead of translating it into "between"?. Eg: if the value entered in the Query by Example as "01:02" the construct statement should not interpret as "between '01' and '02" but should be "='01:02'" or "matches '01:02'". Thanks a lot and Happy New 2011 Year. Long Nguyen RedCross Australia.

↪ replying to Long Nguyen

GARY GU — Thu, 30 Dec 2010 04:32:03 — source: IIUG Forums & Mailing Lists

Try to enter with "=" eg "=01:02". Gary