# Alternative for is\_clean\_data function in dremio 24

**URL:** <https://community.dremio.com/t/alternative-for-is-clean-data-function-in-dremio-24/10435>\
**Category:** Dremio University\
**Created:** [March 22, 2023, 8:26am UTC](https://community.dremio.com/t/alternative-for-is-clean-data-function-in-dremio-24/10435 "2023-03-22T08:26:22Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![sandeep](https://avatars.discourse-cdn.com/v4/letter/s/ecccb3/32.png) [@sandeep](https://community.dremio.com/u/sandeep)\
**Post date:** [March 22, 2023, 8:26am UTC](https://community.dremio.com/t/alternative-for-is-clean-data-function-in-dremio-24/10435/1 "2023-03-22T08:26:22Z")

</div>

I would llike to check if values of a selected column has clean type of data and then cast it accordingly.  
However I don’t find any function in dremio 24 other than,` isnumeric, isfalse, istrue` kind of functions.  
is there any alternative for `is_clean_data` function in dremio 24?

For ex., like below, I am looking for a solution in dremio 24.

```auto
--CREATE TABLE $scratch.test.a AS Select 1 AS a 
--CREATE TABLE $scratch.test.b AS Select 'a' AS a
--SELECT * FROM $scratch.test
SELECT a, is_clean_data(a, 0, 'INTEGER'), is_clean_data(a, 0, 'TEXT') FROM $scratch.test

```

Appreciate any help.  
Thanks,  
Sandeep