Month: February 2016

Where’s Waldo? – Using Logical and Text Functions to Find “_W”

When you’re performing column matching and the primary key of one table does not exactly match the similar column in the second table, data manipulation may be necessary. Using calculated columns, you could create the necessary values for column matching. This example demonstrates how to use a custom expression to extract a string of characters from a column when the number of character values may not be consistent.

Read More