Search: substring

More Results

Sort by: Relevance | Date

  • Running AS/400 query to find records based on date

    Is there a quick way of running an AS/400 query to select records based on current sysdate? I know you can get the current date using the Current command, but I... Answer   |   Search400.com

  • How to use SQL's POSITION function with substrings

    Expert Rudy Limeback explains with an example how to use the SQL POSITION function with substrings. Ask the Expert   |   SearchOracle.com

  • Substring function

    I want to get the first eight characters of a text field, but I also need to get more values for other fields of three tables. I don't know what form of the "substring" function is correct to use. Or is there another function that I could use?
    ... Ask the Expert   |   SearchOracle.com

  • Update a substring of a column value

    How do I update the substring of a string value? I tried the above in TOAD and I got "ORA-00927: missing equal sign." Ask the Expert   |   SearchOracle.com

  • Joining on a substring of a column

    Using MS Access:

    SELECT * FROM EEqry E, LoanOfficers L 
WHERE E.FirstName = L.FirstName

    How can I change this SQL statement so that both FirstName fields only compare the value up to the first space?... Ask the Expert   |   SearchOracle.com

  • Another Search / Replace Substring

    Search and replace of a substring with the ability to replace the first occurence, last occurence or every occurence of the string.
    Sub LibReplaceString( sourceStr As String, fromStr As String, toStr As String, what As Integer )

    '... Tip   |   SearchDomino.com

  • Dynamic SQL statement in an RPG program

    DB2/400 and DB2 UDB expert Kent Milligan discusses how to substring a character field on an SQL join statement. Ask the Expert   |   Search400.com

  • Sorting substrings of different lengths numerically

    I have a table which contains IP addresses, such as 192.192.192.50. I want to display the table sorted by IP address (which is the primary key, a string), but unfortunately 192.192.192.19 will appear before 192.192.192.2!

    The general... Ask the Expert   |   SearchOracle.com

  • JavaScript for @ReplaceSubstring

    This JavaScript mimics @ReplaceSubstring. Tip   |   SearchDomino.com

  • Javascript alternative to @ReplaceSubstring

    When pushing values in and out of the Query_String I often have to replace spaces with "+" symbols. This is a very simple method for doing this.

    string.replace is standard within javascript 1.2
    according to Netscape:- (JavaScript 1.3:... Tip   |   SearchDomino.com

Search Again: