This was the setup I have used in the past. The advantage over MC/N , MC/A is that it is more flexible if you want to be very specific, or if you want to allow some non alphanumerics as well, since you choose which characters are allowed to stay.
George > -----Original Message----- > From: [email protected] [mailto:u2-users- > [email protected]] On Behalf Of Anthony W. Youngman > Sent: Sunday, January 24, 2010 7:06 PM > To: [email protected] > Subject: Re: [U2] The opposite of Export is.. sometimes not Import... > > > >CONVERT(OCONV(OCONV(PartNumber,'MC/N'),'MC/A'),'',PartNumber) > > Slightly longer, but I'd do it as follows > > CONVERT( "ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890", "", > UPCASE(PartNumber)); CONVERT( @1, "", UPCASE(PartNumber)) > > _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
