**Source URL:** https://limited.veevavault.dev/sitevault/vql/functions-options/trim.md

# TRIM()



By default, VQL returns picklist field values with a namespace suffix, such as the `__c` in `hematology__c`. In v25.1+, use the `TRIM()` function in the `SELECT` clause to return picklist field values without the namespace suffix, such as `hematology`.

## Syntax {#Syntax}

```
SELECT TRIM({field})
FROM {query target}

```

The `{field}` parameter must be the name of a field of type *Picklist*.

## Query Examples {#Query_Examples}

The following are examples of queries using `TRIM()`.

### Query {#Query}

The following example returns both the full and trimmed *Therapeutic Area* field from *Product* records:

```
SELECT id, therapeutic_area__c, TRIM(therapeutic_area__c) AS therapeutic_area_trimmed
FROM product__v

```

### Response {#Response}

```
{
   "responseStatus": "SUCCESS",
   "responseDetails": {
       "pagesize": 1000,
       "pageoffset": 0,
       "size": 2,
       "total": 2
   },
   "data": [
       {
            "id": "00P000000007001",
            "therapeutic_area__c": [
                "endocrinology__c"
            ],
            "therapeutic_area_trimmed": [
                "endocrinology"
            ]
        },
        {
            "id": "00P000000008001",
            "therapeutic_area__c": [
                "hematology__c"
            ],
            "therapeutic_area_trimmed": [
                "hematology"
            ]
        },

   ]
}

```


---

**Previous:** [TONAME()](/sitevault/vql/functions-options/toname)  
**Next:** [Query Targets](/sitevault/vql/query-targets)