- 1. Cheat Sheet for mySQL vs t-SQL
- / Databases /
- ... haystack) CHARINDEX(needle, haystack [, offset]) String Concatenation CONCAT(string1,string2[,stringN]) string1 + string2 SS v2012+: CONCAT(string1, string2 [, stringN ]) String Substring SUBSTRING( ...
- Created on 31 January 2013
- 2. CharIndex Reverse - find occurrence starting from end of string in TSQL
- / Transact-SQL /
- ... have a string such as the following (column positions added for demo purposes): String1.String2.String3.String4 1 5 10 15 20 25 30 -> length = 31 I'd like to end up with just the last ...
- Created on 28 January 2013
- 3. AutoHotkey Format Date and Format Seconds
- / AutoHotkey /
- ... | Month:=MonthNameArray%Month% TimeString1:=SubStr(val, 12, 4) TimeString1=%TimeString1%%Month% TimeString1:=TimeString1 . SubStr(val, 5, 2) . SubStr(val, 17, 2) . SubStr(val, ...
- Created on 20 September 2011