Can ranges of characters (like ASCII ranges) be used in the REPLACE function?
Rick On Fri, Mar 28, 2008 at 3:00 PM, Joe D'Souza <[EMAIL PROTECTED]> wrote: > ** Has anyone implemented the equivalent of the Oracle TRANSLATE function > in Remedy? > > I have a field where I wish to translate all the alpha characters into > lets say ^ and then replace ^ with null to make that field free of alpha > characters. > > The only way I can think it is possible right now is to have a nested > REPLACE for each character. Any other method? > > I have been asked to avoid direct SQL's as far as I can so I'm going to > resort to Direct SQL as a last resort option.. > > Thanks Thad for responding to that one.. Maybe you know the answer to this > one too :-). Unfortunately on this gig I do not have that much of a luxury > to 'try' it out' > > Cheers > > *Joe D'Souza* > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
