Compare Two Strings And Capture Different Values

Question

Is it possible to compare two strings and find values not present in both? For example,

String 1: [email protected] [email protected]

String 2: [email protected] [email protected] [email protected] [email protected]

Result: [email protected]; [email protected]

Is it possible to use NOT IN or NOT EXISTS to capture those values.

Thanks for any direction.

No. NOT IN and NOT EXISTS do not do what you want at the string level. — Gordon Linoff
– Gordon Linoff, Commented Jul 21, 2020 at 14:48

Gordon Linoff · Accepted Answer · 2020-07-21 14:49:48Z

1

You can use string_split() and aggregation:

select string_agg(coalesce(s1.value, s2.value), '; ')
from string_split(@string1, ' ') s1 full join
     string_split(@string2, ' ') s2
     on s1.value = s2.value
where s1.value is null or s2.value is null;

Here is a db<>fiddle.

answered Jul 21, 2020 at 14:49

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Compare Two Strings And Capture Different Values

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related