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.
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.
Jim Salasek's SQL Server Blog 