It appears that the form you are working with is a Join form. On Join forms field 1 is a combination of the field 1(s) from both of the joined forms with a '|' separator character.
If using field 1 from one of the 2 firms in the join works then you could do a set fields using either the LEFT or RIGHT functions to just get the part of the field you want (or use field 1 from one of the forms itself). Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ravi Sent: Monday, June 23, 2008 4:00 PM To: arslist@ARSLIST.ORG Subject: Re: Integer field sequence number but the field 1 has value like 000000000000032|000000000000032. I was hoping it will be just 000000000000032. [EMAIL PROTECTED]> select REQUEST_ID from aradmin.sprint_mns_interfaceview where TRS_TICKET_NUMBER='1124164'; REQUEST_ID ------------------------------- 000000000000032|000000000000032 Carey Matthew Black wrote: > Ravi, > > Why not use field 1's value? ( You may have a good reason, but > sometimes it helps to know what your trying to do so that the best > solution can be approached in the discussion. Instead of just > answering the question with a simple. "Nothing out of the box that > does that, other than field 1.") > > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"