troubleshooting Question

Split Dual Delimited Strings in TSQL

Avatar of crickpaolo
crickpaolo asked on
Microsoft SQL ServerMicrosoft SQL Server 2005
3 Comments1 Solution614 ViewsLast Modified:
Hi,
I have two table columns each containing delimited strings.  One of them is called LOCAL_PRIMARY_KEYS, and the other is called EXTERNAL_PRIMARY_KEYS.

LOCAL_PRIMARY_KEYS contains: 'Last_Name,First_Name,Birthdate'
EXTERNAL_PRIMARY_KEYS contains: 'LST_NM,FRST_NM,BDATE'

What I want to produce is a string that looks like this:

WHERE Last_Name = LST_NM AND
First_Name = FRST_NM AND
Birthdate = BDATE

How do I do this using only TSQL?  I am using SQL Server 2005.

Thanks in advance.


Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 3 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros