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