Sel * from wo whe (sget(mod_pn,1,slen(mod_pn))) = '-' Ben Petersen
On 19 Aug 2003, at 8:31, Brad Davidson wrote: > How would I extract a list of rows wherein the last character in a text > string is a '-' (dash)? What I want is a listing of all work orders(wo) > from a table where the part number (mod_pn) last character is a dash. A > function of SLOC, SLEN, or ?? > > Thanks for any advice on this. > > -Brad DAvidson >
