Re: [GENERAL] Check whether two strs have at least one shared character.

2007-07-03 Thread Albe Laurenz
Emi Lu wrote: > Is there a simple way/command/function to check whether two > strings have at least one overlap character please? > > For example, > > str1: 05baaa > str2: ooboo > > Query: select str1 ??? str2 ; > > Result: true > > Because b is in both str1 and str2. SELECT str1 ~ ( '[' || s

[GENERAL] Check whether two strs have at least one shared character.

2007-07-03 Thread Emi Lu
Hello, Is there a simple way/command/function to check whether two strings have at least one overlap character please? For example, str1: 05baaa str2: ooboo Query: select str1 ??? str2 ; Result: true Because b is in both str1 and str2. Thank you! ---(end of broadc