Replace (or keep) 1st and 2nd position of a string with multiple conditions
I’m querying a Microsoft SQL database with facilities locations from around the country. Problem is many facilities managers do not know north from south or east from west and have entered the location of their facilities in a wide variety of formats.
SQL CASE Statement: Replace (or keep) 1st and 2nd position of a string with multiple conditions
I’m querying a Microsoft SQL database with facilities locations from around the country. Problem is many facilities managers do not know north from south or east from west and have entered the location of their facilities in a wide variety of formats.