|
Please guide me below mentioned problem String1 = ÁĚĎ String2 = PQĎ I need to find out whether any of the characters in string1 appears in string2. My fuction should exit the loop at the first occurance of any of the string1 character in string2. I do not want to process each of the character in string1 in a loop as i have to process millions of records in the database. Can anyone guide me what sql statement can be written in sql server 2000 or sql server 2005. With Regards Novice
(comments are locked)
|
That will return 9 - the 1-based index of the first occurrance of any of the letters a, b or c
(comments are locked)
|
|
Have you thought of using full-text indexing and using the CONTAINS function?
(comments are locked)
|
|
I know it's an old post, Ben, but did either of these answers solve your problem?
(comments are locked)
|
Your answer
