title: I want to remove part of string from a string
body: <p>Thank you in advance.</p>
  
  <p>I want to remove string after <em>.</em> including <em>.</em>, but length is variable and string can be of any length.</p>
  
  <p>1)Example:<br>
   Input:- <code>SCC0204.X  and FRK0005.X  and RF0023.X and ADF1010.A and HGT9010.V</code></p>
  
  <p>Output:  <code>SCC0204 and FRK0005 and RF0023 and ADF1010.A and HGT9010.V</code></p>
  
  <p>I tried using the charindex but as the length keeps on changing i wasn't able to do it. I want to trim the values with ending with only X</p>
  
  <p>Any help will be greatly appreciated.</p>