Windows OS: Alt Codes / Symbols / Special Charactershttps://www.joellipman.com/articles/microsoft/windows-os/windows-os-alt-codes-symbols-special-characters.html

03 June 2021 Codes" in a search engine for a full list. Meanwhile, here's some that you may need frequently: Currency ¢ Cent sign 0162 £ British Pound 0163 € Euro currency 0128 ¥ Japanese Yen 0165 ƒ Dutch Florin 0131 ¤ Generic currency symbol 0164 Mathematics ÷...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Convert to Proper Case in T-SQLhttps://www.joellipman.com/articles/database/t-sql/convert-to-proper-case-in-t-sql.html

04 June 2014 SELECT ufn_ProperCase([Surname]) FROM employees Additional: Note how the above doesn't convert postal codes, specifically British postcodes, which isn't included in the examples above because the function was only going to be applied to names and titles...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

T-SQL DateTimestampshttps://www.joellipman.com/articles/database/t-sql/t-sql-datetimestamps.html

23 March 2011 setup Windows XP SP3 MS SQL Server Management Studio 2008 SQL Server 2008 R2 Regional Setting: London BST (British Summer Time) Tuesday the 11th of October 2011 at 06:00am: CONVERT(CHAR(19), CURRENT_TIMESTAMP, 0) Oct 11 2011 6:00AM CONVERT(CHAR(8),...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

Search a database with SOUNDEXhttps://www.joellipman.com/articles/database/search-a-database-with-soundex.html

11 October 2012 it did NOT pick up were words like "dayname" and "dynamite". Additional Notes Our database and environment need to be in British English, the collation used in the example above is where the server is set to "Latin1_General_CI_AS" [General Latin,...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: en-GB

Upgrading a Joomla 1.5 module to Joomla 2.5https://www.joellipman.com/articles/cms/joomla/upgrade-a-joomla-1-5-module-to-joomla-1-6.html

11 February 2011 are a few more tweaks to do. How? For demo purposes we will be referring to a Joomla module called "mod_moduletoupgrade" in British English (en-GB). I don't think it actually exists in reality but you replace the name "moduletoupgrade" with whatever...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

SSIS Multiple Lookups in onehttps://www.joellipman.com/articles/microsoft/ssis/ssis-multiple-lookups-in-one.html

05 August 2014 ------------------------------- 0000000001 1234567 MR Mr Joe Lipman M Male 5826 Philippines 000 England 39 British National 39 Other Asian Background 0000000002 0987654 MAJ Major Big Bird M Male 771 United States of America 771 United States of America...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

Live WebCam feed of Bournemouthhttps://www.joellipman.com/articles/web-development/live-webcam-feed-of-bournemouth.html

30 January 2013 Oh well, this is where technology has come to the rescue and returned my calming view... Note: I think this is running in British Summer Time (BST) rather than GMT or it's clock is seriously off. Otherwise it's a picture from the future (see photo...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

MS Excel: Convert a text to a numberhttps://www.joellipman.com/articles/microsoft/excel/ms-excel-convert-a-text-to-a-number.html

15 November 2013 what a NUMBER was? I have a column full of currency values which I want to convert, specifically Philippine pesos to British pounds (sterling). When I multiply the Philippine peso by the conversion rate, it returns #VALUE! How? The problem is that I...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB