=StrConv("JOHN DOE", vbProperCase)
This now becomes John Doe… Read the rest
Month: August 2014
SQL Server – Case-Sensitive search in SQL
If your sql server is installed with the default collation of case-insensitive, you can accomplish this in sql instead.
You can determine if your installation collation is case-insensitive by running this query:
SELECT SERVERPROPERTY ('Collation')
GO
If the result is … Read the rest
SQL Server Reporting Services (SSRS) – Alternate row colors with no group, 1 group, or multiple groups
In order to do alternate row coloring for an SSRS report that has grouping, you need an expression for your BackgroundColor property different than the typical:
=iif(rownumber (nothing) mod 2 = 0, "LightGrey", "White")
You can use the following expression … Read the rest
SQL Server – Turning a Comma Separated string into individual rows
Let’s say you have a column in a table that is comma delimited. The value in the column is ‘APPLE, ORANGE, GRAPE’. You want to break down this string value into individual rows. You may also want to create an … Read the rest
FileSeek – Clear LastUsed data in registry
In Regedit:
HKEY_CURRENT_USERSoftwareMicrosoftBinary Fortress SoftwareFileSeek
Remove all the data inside the Multi-String values that start with LastUsed.
