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:[email protected]] On Behalf Of ccrashh Sent: Monday, January 25, 2010 12:53 PM To: [email protected] 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:[email protected] 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:[email protected] ARSlist: "Where the Answers Are"
