Attempting to run the above code I receive error:
SELECT *, CASE comment WHEN CHARINDEX(CHAR(10), comment) Then 'True 10' WHEN CHARINDEX(CHAR(13), comment) Then 'True 13' ELSE 'False' END AS CheckReturn FROM #Temp
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”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.