Skip to content

Jim Salasek's SQL Server Blog

Sharing what I learn about Sql Server

  • Home
  • About
  • Contact

Recent Posts

  • Powershell: ReportingServicesTools. Download all RDL files from a SSRS folder. May 9, 2023
  • SSIS error: 0xC0048021SSIS April 4, 2023
  • Easy way using SSIS to copy files to S3 storage. March 7, 2023
  • SSIS Hresult: 0x80004005 Consider using the WITH RESULT SETS clause to explicitly describe the result set.SSIS Hresult: 0x80004005 February 8, 2023
  • How to install SQL Server Reporting Services (SSRS) 2022 January 4, 2023
June 2023
M T W T F S S
 1234
567891011
12131415161718
19202122232425
2627282930  
« May    

Tag: extract characters

Extract string before a special character

Here is an easy way to get (extract) all of the characters before a special character in a string.  In our example we have a listing of email addresses and we want to get the name before the @domain.

Continue reading Extract string before a special character

Posted on April 18, 2017March 25, 2017Categories Hints and TipsTags charindex, extract characters, extract string, substringLeave a comment on Extract string before a special character
Create a website or blog at WordPress.com
  • Follow Following
    • Jim Salasek's SQL Server Blog
    • Join 27 other followers
    • Already have a WordPress.com account? Log in now.
    • Jim Salasek's SQL Server Blog
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar