https://www.webmaster-forums.net/crss/node/1014332 en https://www.webmaster-forums.net/web-database-development/replace-sql-server#comment-1082611 <p>This wokred but I have not yet figured out how to do this with the ISNull. I guess it is a good thing there will never be any nulls in that column.</p> <p>Replace (SN.shortname, ',' ,'') as ShortName</p> Fri, 18 May 2001 19:24:19 +0000 1aspfan comment 1082611 at https://www.webmaster-forums.net