I just attempted to update an address in one of our company's database tables. The query looked like this:
UPDATE PUB.EST_ADDRESS
SET pAddress = '39 E Chicago Ave.'
WHERE ID = '[id]'
This query updated all my PUB.EST_ADDRESS.pAddress to "39 E Chica".
How in world do you update/insert anything with "go" in the word?
Any and all assistance anyone can provide would be much appreciated.
UPDATE PUB.EST_ADDRESS
SET pAddress = '39 E Chicago Ave.'
WHERE ID = '[id]'
This query updated all my PUB.EST_ADDRESS.pAddress to "39 E Chica".
How in world do you update/insert anything with "go" in the word?
Any and all assistance anyone can provide would be much appreciated.