Today I had an issue that someone changed format of a string pattern our SQL was expecting. I came across a function written by George Mastros that addressed my SQL needs. Long story short we have a string with text then a number and some more text. What we need is to extract the numeric value from this […]
Category Archives: SQL Server
SQL server date format issue – kind of
So you find yourself that your software was written for say UK English but the system is installed from US English. This can happen in numerous cloud migration projects. Well the issue can be overcome in several ways but one way that I liked in particular is to alter the user’s default language. This assumes […]