Search - Joel Lipman .Com

1. PHP: First name and Initial of Surname: / Personal Home Page /; What? A note for myself on some code to convert a string of two names into a string made up of the first name and then using the initial of the second name. -- What I have John Smith Fred.Bloggs -- ...; Created on 27 March 2014
2. Zoho Deluge: Proper Case for Names: / Zoho /; ... " :|JOEL|: ", true).proper(); v_FirstName = v_FirstName.replaceAll(" :|joel|: ", "-", true); // // Names starting with Mc, O', D', I' l_ExceptionPrefixes = ; // // deal with double barrelled surnames l_FormattedLastName ...; Created on 13 July 2023
3. Zoho Deluge - Generate 5 Letter Booking Retrieval Code: / Zoho /; ... as well as the customer's surname (method #1 would not be guessed by date/time): string generateRetrievalCode() { // init v_Output = ""; l_Output = List:String(); l_Alphabet = ; ...; Created on 09 May 2019
4. Convert to Proper Case in T-SQL: / Transact-SQL /; ... Examples of usage: SELECT ufn_ProperCase([Surname]) FROM employees Additional: Note how the above doesn't convert postal codes, specifically British postcodes, which isn't included in ...; Created on 04 June 2014
5. T-SQL: Parse an XML value: / Transact-SQL /; ... of child node containing string "SURNAME" SELECT ( SELECT c.value('local-name(.)', 'nvarchar(50)') FROM Event_XML.nodes('/*/*[contains(local-name(.),"SURNAME")][1]') AS r(c) -- added ...; Created on 27 March 2014
6. SSRS: Performance Improvements: SELECT TOP: / SQL Server Reporting Services /; ... in 0.4 seconds. So where's the problem? How? Left to its own devices, a search for "SMITH" as a surname would make the report spin for about 10 minutes without the possibility to cancel (link not ...; Created on 07 March 2014
7. Regular Expressions in SQL: / Databases /; ... REGEXP_LIKE(S_SURNAME, '[^a-zA-Z0-9]') -- returns all rows where the student surname contains non-alphanumeric characters -- eg. O'Brien will be returned SELECT * FROM STUDENTS WHERE REGEXP_LIKE(S_SURNAME, ...; Created on 09 January 2014
8. T-SQL concatenate an incremental row number: / Transact-SQL /; ... FirstName Surname 1 Joel Lipman 2 Another Joe TABLE: Qualifications -------------------------------------------------- ID Employee Subject ...; Created on 24 May 2013
9. Trim in T-SQL and SSIS: / SQL Server Integration Services /; ... equation can be written: Table: DMExtractEmployeeTable ID ForeName SurName --------------------------------- 1 Joel Lipman 2 JOE THE GREATEST DECLARE ...; Created on 14 May 2013
10. Convert a delimited string to table: / Databases /; What? This is a quick note to show you how to convert a given comma delimited string into a database table: Given: "Title,Forenames,Surname" Return: ID Value ------ ---------------- ...; Created on 26 October 2012
11. Search a database with SOUNDEX: / Databases /; ... 1 DnYa myTable2.FeePayerCode 1 dnYA myTable2.DisabilityCode 1 DyNa myTable3.EthnicityCode 1 DñYà myTable3.OriginalSurName 1 DNYA myTable4.RegionCode 4093 -- note how it picked ...; Created on 11 October 2012
12. Inline Labels in Form Fields using Javascript: / JavaScript /; ... giving it the label value to indicate to the user to enter their Name (as in forename or surname). onFocus() - What to do when the user moves their cursor into the field or clicks on it. In this specific ...; Created on 21 August 2012
13. DataJumble - Shuffling characters in a data value: / Transact-SQL /; This was called a Data-Scrambling Function but it depends on what you mean by "scrambling". This is a function which merely uses the same characters but switches their order randomly, so I've renamed ...; Created on 01 August 2012
14. No rows returned in Oracle causes SP to fail: / Oracle PL/SQL /; ... NVL(student_details.studentSurname, 'Smith') "SURNAME" FROM student_details WHERE student_details.studentID = v_studentreference; This errors when ...; Created on 24 January 2012
15. Returning Oracle Stored Procedure Resultset in SSRS: / SQL Server Reporting Services /; ... INITCAP(b.p_title) || ' ' || INITCAP(b.p_forenames) || ' ' || UPPER(b.p_surname) || ' (' || INITCAP(To_char(b.p_dob, 'DD-MON-YYYY')) || ')' "p_STUDENT_DETAILS", ...; Created on 19 January 2012