Blog

(Articles with tag:perform data cleansing) - Remove Filter

Apr 06/2019

The 10 Best Features of MS Access to Maximize Value

Is Microsoft Access the database environment that your business should be using? We’re going to take a look at 10 of the most convenient and powerful aspects of MS Access to help you make a decision. The Farber Consulting Group Inc. has the MS Access consultants and developers to help you take advantage of these many benefits and more.

Mar 28/2011

String Manipulation on large data using LIKE operator or PATINDEX

The idea is to perform data cleansing on the Date and Time field from different formats into a unify format such as: YYYYMMDD. Here is a sample data to be used for the data cleansing that I will perform below...