SQL to search for a sub-string of a minimum length of 15 characters in a source string
Hi all,
I have an urgent problem as follows:
I need to search for any word(or more generally the search string which is a
continuous set of characters/numbers etc. except the space) which has a length of 15 characters or more
in a large string(the source string).
For example:
Consider the string(source string): 'exxxxx R001234juuuAA JH JHGJHG KHKJK65465465 NBVMNBMBEWRE234H.,H '
Here the search string: 'NBVMNBMBEWRE234HH' has a length 19.
So clearly the source string has a search string of length greater than or equal to 15.
Is it can be done in a single SQL which will give the output say 1 for the presence of the search string with required criteria or 0 otherwise?
0