Eric asks: > I need to create an if statement based on a field with more > characters than i need the if statement to be. I need only the > first five characters to be used in creating the statement. Example, > if the field contains "inso5", if need it to return "ID Card Advantage". > But sometimes the field will have extra information in it like > "inso5*na6"
Eric, this is very simple to accomplish! if(Left(Field("CardData"),5) == "inso5") return "ID Card Advantage"; else return "Whatever..."; Rob ************** Rob Domaschuk Training and Communications Developer Printable Technologies(tm), Inc -- Users of FusionPro Desktop have unlimited free email support. Contact Printable Support at [EMAIL PROTECTED] -- View FusionPro Knowledge Base, FusionPro Samples at www.printable.com/vdp/desktop.htm -- You are currently subscribed to fusionpro as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] -- -- Note: All e-mail sent to or from this address will be received or otherwise recorded by the e-mail recipients of this forum. It is subject to archival, monitoring or review by, and/or disclosure to someone other than the recipient. Our privacy policy is posted on www.printplanet.com --