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
Expert Rudy Limeback explains with an example how to use the SQL POSITION function with substrings. Ask the Expert | SearchOracle.com
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
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
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
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
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
I have a table which contains IP addresses, such as 188.8.131.52. I want to display the table sorted by IP address (which is the primary key, a string), but unfortunately 184.108.40.206 will appear before 220.127.116.11!
The general... Ask the Expert | SearchOracle.com
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.