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 Wanet Telecoms Ltd 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: des0929
  • Content: Threads
  • Order by date
  1. des0929

    Excel function question

    What function would I use to take a string and parse it the following way: Original string: 20BPP0355 1. Need to find the "BPP" and bring every value to the right of "BPP" into a new field: New string: 0355
  2. des0929

    MS Access Query: IN List sytax

    Does anyone know the MS Access query sytax for an in list condition FoxPro example: Select * from table where inlist('Tom','Mary') Thanks.
  3. des0929

    CLOB datatype

    I'm trying to ODBC connect MS Access to my Oracle database. I have problems with tables that have CLOB format fields. How can I get around this problem? Can a view be created that can change the datatype of the CLOB field(s) into a VARCHAR format? If so, how is this done...Oracle function...
  4. des0929

    Parsing question--inStr

    I have a description field --DESCR--in Access. The field is the result of the concatenation of 3 fields in another application. I would like to split this DESCR field. Here is an example: DESCR ---------------------------------- SCENARIO: Regional Reimbursable Commodity SCRIPT: REM1000 The...

Part and Inventory Search

Back
Top