Detect if data has character in it

Chakra shared this question 1 year 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