Some time ago I had to build an integration app that would on occasion query from a SQL Server 2012 database and based on the […]
Database, SQL, SQL Server
How to achieve the LIKE IN effect in SQL Server
SQL Server does not natively support a “LIKE IN” clause. For instance the following example is not valid: Luckily there is a way to achieve […]
SQL, SQL Server
Remove leading zeroes from varchar
The following example shows one way how you can remove leading zeroes from a varchar column in SQL Server: Returns: