title: In Tsql, how do i replace a value if the value is not null?
body: <p>For a directory, I want the words "visit website" to appear only if the member has entered a website. I do not want to retrieve the actual web site url.</p>
  
  <p>Replace and Coalesce seem to work only if the value is null. </p>
  
  <p>This is certainly not working</p>
  
  <pre><code>SELECT replace (eweb,'website','website') as value 
  from Web_FacStaffdir 
  where eweb is not null
  </code></pre>