Charindex is a great function for working with emails:
left(Email, charindex(‘@’, email) -1) + ‘@invalidemail.com’ as email,
Recent Comments
Archives
- February 2024
- January 2024
- September 2023
- April 2023
- March 2023
- February 2023
- December 2022
- July 2022
- May 2022
- March 2022
- February 2022
- December 2021
- October 2021
- December 2020
- October 2020
- August 2020
- July 2020
- May 2020
- April 2020
- February 2020
- October 2019
- August 2018
- July 2018
- May 2018
- April 2018
- November 2017
- March 2017
- February 2017
- November 2016
- May 2016
- January 2015
- October 2014
- September 2014
- August 2014
- May 2014
- March 2014
- January 2014
- December 2013
- September 2013
- August 2013
- June 2013
- May 2013
- April 2013
- January 2013
- November 2012
- October 2012
- September 2012
- July 2012
- May 2012
- April 2012
- March 2012
- February 2012
- December 2011
About Me