Detect if data has character in it

Chakra shared this question 19 months ago
Answered

Hi,

Is there any way to identify if the data in the report column has some sort of character in it?

I've attached a screenshot for your reference. Appreciate your feedback on this.

Thank you,

CT

Comments (1)

photo
1

Hi CT,

yes, there are a few different ways to do this (depending on which DBMS you are using), here is a general way to do it that should work on any DBMS:

06a7b69b91fc0324bfda4c9ec088f63cI hope that helps you meet your reporting requirements.

regards,

David