Pattern searches beyond ‘%string%’.

(Kenneth Fisher) I was asked today to take a table with a social security column and put all 0s if the column had any letters in it. This is the typical social security column that actually has more rows with ‘XXX-XX-XXXX’ than it does valid SSNs. There are even cases that look like ’1234-AB-56TS’ e

Read More - Register for Free Membership