SQLServerCentral » Latest topics
How to find the first recurring character of a string.
I have a query that finds the first recurring character in a string.
For eg : if @str = 'ABCCDA' then i should C as answer as it recurred first and not A(it also recurred but C recurred before it). If there are no recurring charcters then it should r
For eg : if @str = 'ABCCDA' then i should C as answer as it recurred first and not A(it also recurred but C recurred before it). If there are no recurring charcters then it should r
No comments:
Post a Comment