I need to create a search which will search for a string (ie. "LMNOPQR"), then search that minus a character (ie. LMNOPQ") if no records match and so on.
I would like to have this OnReturn of the character field. I have experimented with writing direct SQL and/or using a chain of active links with *SUBSTR*<http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/functions162.htm> to remove the last character Has anyone done this in Remedy? I'd like to limit this to Remedy code but SQL is an option. -SMR _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"