To use the percent symbol as an explicit text character within a LIKE operation you must enclose the symbol in brackets (page 672, ARS 6.3 Applications Basic)
So I would say "%[%]%" Mark -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of ccrashh Sent: Monday, January 25, 2010 12:53 PM To: arslist@ARSLIST.ORG Subject: Check to make sure Char field doesn't contain a Percent sign (%) I know you can do a Run If with LIKE "%[a-z]%" to check for the existence of alpha characters from a to z in a field. However, how can you check to see if a char field contains a "%" sign? _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
