Thanks for you help. So would the function go on the top of the proc? not sure what you did here. but thanks.

Using my examples plus this one I have one more problem I get more information that is needed fort he emai sometimes. I get for example 2 I am getting...

Got it it was the defining of trailing should be PosOfAt + 1

It has something to do with this part of the email

+

LEFT(TRAILING, CHARINDEX('...

example 1 (not all have email: before the email that is why I look for the @ sign.

FirstName LastName CustomerN OppNo note

KeithZwar$000879 ...

I lied. I found a problem. I am reading right now about cross apply. Right now my email's are adding in an extra letter and and an extra @ sign....

Thanks everyone. Works great.

If I run this I get data back.....

with prese1 as(

Select top 8 s.SalesRepId, s.FirstName, s.LastName, c.CustomerNo, h.OppNo, ' ' + n.Note AS Note

from SalesLink_SalesRep s,

SalesLink_Prospect_SalesRepCustomerXrf c,

Opportunity_Header...

Yes there is data for 238 for top 8. I run just pulling the notes and it works. but as soon as I add the '%[0-9A-Za-z.][@] [0-9A-Za-z.]%'

It doesn't put any...

Ok, I know you are sick of me. I know I am just going crazy over this. I have to get this done and can't figure this out...I can't put...

I have the following Microsoft SQL but it doesn't know what c(email) is and if I take it out I get no results. 🙁

--Get all the notes from the customers...

ok but that is just making them not be able to put the email in the notes this way. I can't change that. This is another company that does it...

Okay everyone, you say to do #1 solution I am confused on which one you are talking about. I have just tried this one...

WITH presel AS (

SELECT s.FirstName, s.LastName, c.CustomerNo,...

Ok, thanks. I found one of them that is making it blow up. It is that the note only has earl@dcande.com with nothing else so no space before the...

I tried this but it didn't work. I don't know what the emails are going to be they are from all over the U.S. There are over 4000 records that...