---
title: "QQ - How do I flag records that contain numeric data for a specific field?"
slug: "qq-how-do-i-flag-records-that-contain-numeric-data-for-a-specific-field"
updated: 2022-09-27T17:35:29Z
published: 2022-09-27T17:35:29Z
canonical: "docs.datajet.app/qq-how-do-i-flag-records-that-contain-numeric-data-for-a-specific-field"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.datajet.app/llms.txt
> Use this file to discover all available pages before exploring further.

# QQ - How do I flag records that contain numeric data for a specific field?

I have a field that has a mix of numeric and string data in it - I can't work with the records that have the numeric data, so i want to flag them so that I can remove them from calculations - how do i do this?

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1664205582786.png)

We can approach this problem using the ICAST function. ICAST will cast any fully numeric data to an integer, but any alphanumeric data as null. In the example below, ICAST2 contains only numeric data - all other data has been mapped as null:

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1664299611753.png)

We can now apply the null data as a filter on StartStation Name (i.e., keeping only data that couldn't be mapped to a numeric field) and we end up with a cleaned StartStation Name that doesn't contain any numeric data:

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1664300036212.png)