troubleshooting Question

sql server query

Avatar of PeterBaileyUk
PeterBaileyUk asked on
Microsoft SQL ServerSQL
18 Comments1 Solution490 ViewsLast Modified:
I have this query I would like to get only the rows where the ascii sum is the same but the text dont match. ie

A4 Ultra s line vs a4 s line ultra with a view to later correct the string.

SELECT tw.StrShort, COUNT(tw.strshort) AS TotalClientCodes, dbo.func_ASCIIEncodeString(tw.StrShort) as asciisum
FROM TblWords tw
WHERE strfull like'a4%line%'
group BY tw.StrShort
ORDER by tw.StrShort

example
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 18 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 18 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros