Skip to content

Instantly share code, notes, and snippets.

@n-tran

n-tran/fixGeoName.sql

Last active December 18, 2015 11:49
Show Gist options
  • Save n-tran/5778726 to your computer and use it in GitHub Desktop.
Save n-tran/5778726 to your computer and use it in GitHub Desktop.
Download ZIP
had some bad quotes(") in the name
Raw
fixGeoName.sql
use mip_portal
go
select geo_name, rtrim(ltrim(REPLACE(geo_name,'"','')))
from geo
where geo_set_id = 169
order by geo_name
--------------------------------------------
--CODE BELOW HAS ALREADY BEEN EXECUTED
--------------------------------------------
/*
update geo
set geo_name = rtrim(ltrim(REPLACE(geo_name,'"','')))
where geo_set_id = 169
*/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment