I know, sorry about that. Got distracted thinking about a more probable use for it. I did write something with parsename, which is very helpful and probably smarter than messing...

Well, this gets me the very end of an email. Not exactly what I was looking for. Oh well.

with rt as (

select right(email, len(email) - charindex('@', email)) as [rtemail]

from...

That is pretty...

I don't have a way to test this, but I had to do something similar with DOB matching on names between two tables recently, and used something like:

select h.f_name, h.m_initial,...

If anyone is interested, I wrote a pretty useful email validation case statement. I know that I probably missed some domains, and I didn't touch two character country domains, but...

Hot damn. Thank you. Got it working by adding this section:

SET @strCount=0

SET @Count =1

Start6: --Label

SELECT @strFind=SUBSTRING(@email,@Count,2)

IF @strFind LIKE '%.@%'

OR @strFind LIKE '%@.%'

BEGIN

SET @chkEmail = 106

GOTO RR

END

SET @count=@Count+1

IF @Count <= len(@email)

BEGIN...

I think the question is if there's a way to have something other than NULL next to the rollup count? That's actually pretty interesting, if possible.

id ...

That's really cool. Never would have guessed that would work. I had a fairly similar query based on employee size and SIC codes, that I just changed up a bit...

dhananjay.nagarkar (4/14/2013)

---

Sure I would love to share-

Here's what I did-

created 3 temp tables with the filelds I need for each with same order, data type.

then UNION the 3 selects.

then...

Sean Lange (4/15/2013)

---

Well you could create your own IsAlpha. I would extend the version you found to at least include spaces and periods.

something like this might help you along.

declare @ScalarVal...

Sean Lange (4/15/2013)

---

erikd (4/15/2013)

---

Sean Lange (4/15/2013)

---

ISAPLHA?? What would you be testing for? Not exactly sure what...

Sean Lange (4/15/2013)

---

ISAPLHA?? What would you be testing for? Not exactly sure what "woogy symbols" are....

Really?! There's not an ISALPHA or anything to test for woogy symbols? That's... :unsure:

It's going to be a few drinks before I attempt that.

:blink:

opc.three (4/12/2013)

---

SET @sql = 'EXEC master.sys.xp_cmdshell ' +

'''COPY \\server\SurveyComputing\Sample\SentToSPSS\' + @data_file +

'+\\server\SurveyComputing\Sample\SentToSPSS\' + @file_name +

' \\server\SurveyComputing\Sample\SentToSPSS\'...