Search - Joel Lipman .Com

1. Windows OS: Alt Codes / Symbols / Special Characters: / Windows OS /; ... sign 0162 £ British Pound 0163 € Euro currency 0128 ¥ Japanese Yen 0165 ƒ Dutch Florin 0131 ¤ Generic currency symbol 0164 Mathematics ÷ Division sign 0247 ° Degree symbol 0176 ¬ ...; Created on 03 June 2021
2. SSIS Multiple Lookups in one: / SQL Server Integration Services /; ... British National 39 Other Asian Background 0000000002 0987654 MAJ Major Big Bird ...; Created on 05 August 2014
3. 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
4. MS Excel: Convert a text to a number: / Excel /; ... to British pounds (sterling). When I multiply the Philippine peso by the conversion rate, it returns #VALUE! How? The problem is that I have a column which includes the currency symbol as per the ...; Created on 15 November 2013
5. Live WebCam feed of Bournemouth: / Web-Development /; So having moved desk from one side of the room to another, I have lost my view of the sea. Oh well, this is where technology has come to the rescue and returned my calming view... Note: I think this ...; Created on 30 January 2013
6. Search a database with SOUNDEX: / Databases /; ... up DyNa as matching DNYA. -- values 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 ...; Created on 11 October 2012
7. T-SQL DateTimestamps: / Transact-SQL /; My 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), ...; Created on 23 March 2011
8. Upgrading a Joomla 1.5 module to Joomla 2.5: / Joomla /; ... have only ever changed the words to but for more stability, there are a few more tweaks to do. How? For demo purposes we will be referring to a Joomla module called "mod_moduletoupgrade" in British ...; Created on 11 February 2011