May 3, 2007 #1 analytics2006 MIS Joined Apr 13, 2007 Messages 34 Location US How can I remove Punctuation from the address field like listed below? 555 S. 3829 W.#
May 3, 2007 #2 gmmastros Programmer Joined Feb 15, 2005 Messages 14,912 Location US Use the replace function. Select Replace('555 S. 3829 W.#', '.', '') -George Strong and bitter words indicate a weak cause. - Fortune cookie wisdom Upvote 0 Downvote
Use the replace function. Select Replace('555 S. 3829 W.#', '.', '') -George Strong and bitter words indicate a weak cause. - Fortune cookie wisdom
May 3, 2007 #3 SQLDenis Programmer Joined Oct 1, 2005 Messages 5,575 Location US use replace, example Code: create table blah222(Address varchar(666)) insert blah222 values('555 S. 3829 W.#') select *,'before' from blah222 update blah222 set Address = replace(Address,'.','') select *,'after' from blah222 Denis The SQL Menace -------------------- SQL Server Code,Tips and Tricks, Performance Tuning Google Interview Questions Upvote 0 Downvote
use replace, example Code: create table blah222(Address varchar(666)) insert blah222 values('555 S. 3829 W.#') select *,'before' from blah222 update blah222 set Address = replace(Address,'.','') select *,'after' from blah222 Denis The SQL Menace -------------------- SQL Server Code,Tips and Tricks, Performance Tuning Google Interview Questions