troubleshooting Question

Ignore matching values when using a case when statement

Avatar of Basssque
Basssque asked on
Microsoft SQL ServerOracle DatabaseMicrosoft SQL Server 2005Microsoft SQL Server 2008SQL
17 Comments1 Solution110 ViewsLast Modified:
Is there a way that I can specify that I'd like to ignore any instances of the following in this case when statement?
anything following the letter x

case when length(CONTACTS.CNT1_CPHONE) != 12 then CNT1_CPHONE||'  <-- invalid_length' else CNT1_CPHONE end CNT1_CPHONE
Join our community to see this answer!
Unlock 1 Answer and 17 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 17 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