Something like this?

SELECT *

FROM @Client cl

WHERE EXISTS( SELECT 1

FROM @ValidDates vd

WHERE cl.ValidDate BETWEEN vd.StartDate AND vd.EndDate)

Lynn Pettis (6/12/2013)

---

Yep, easy except...

As easy as

SELECT UserID,

MAX(Email) Email

FROM MyTable

GROUP BY UserID --Edited post to add this line

If you need a specific email, you need to define...

Don. (6/12/2013)

---

Thanks for the reply Luis.

This script seems to do what I want with the demo data.

Select top 100 *

From CONTSUPP

Where RECTYPE = 'C'

AND ( CONTSUPREF...

opc.three (6/12/2013)

---

A CLR function that uses regular expressions, finding a "word" in a string that equals "LC" is a simple reg ex task, could also be a good option to...

A similar approach to Sean's iTVF.

WITH Codes(code) AS(

SELECT *

...

Maybe a recursive CTE can help you. Note that I'm including the sample data in a CTE and you might not need it when you apply the solution.

WITH...

That's because the first script is expecting a character after and a character before the LC, that's why I added trailing and leading spaces to the column. Try adding a...

Everyone makes mistakes, so continue to participate in this forum, that way we all win and learn. 😉

Deque (6/11/2013)

---

Luis Cazares (6/11/2013)

---

You have the right idea,...

I was going to suggest that as well 😀

You might miss some desired results if you have other delimiters such as tabs or slashes.

Be sure to add them between the brackets[] or to replace them with a space...

You have the right idea, but you're not...

Sean Lange (6/11/2013)

---

No, you cannot update a function. A table valued function or a...

You should use something like this

SELECT spa.StudentID, spa.AddressID, itv.streetApt, ama.city, ama.state FROM stuPropertyAddress spa

INNER JOIN dbo.addMasterAddress ama ON spa.addressID=ama.addressID

CROSS apply dbo.FNC_GetStreetApt2(spa.StudentID) itv

WHERE spa.StudentID = @studentID