Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: srosa
  • Order by date
  1. srosa

    Reformat the acct number in an sql result

    Between your initial suggestion and trying some things on my own, I solved my last problem pretty simply. I just added [||'R'] to the end of the formula and got the result I needed. Thanks for you help.
  2. srosa

    Reformat the acct number in an sql result

    Thanks, but I still have a problem. I realized that the system is not seeing the 'R', 'dashes' or 'period'. The count begins at 'a'='1','b'='2',etc. and ends with 'l'='12'. I adjusted the formula and it works except that it leaves off the 'R'. The 'R' is definitely part of the raw strap so...
  3. srosa

    Reformat the acct number in an sql result

    I'm using a query feature in our company's application to communicate with Informix 3.8. I need to change the format of a resulting account number list in order to import this result to another program and link data based on that number. This is an example of my statement: Select detail.strap...

Part and Inventory Search

Back
Top