**Source URL:** https://general.veevavault.dev/qualityone/vql/functions-options/richtext.md

# RICHTEXT()



By default, VQL returns only the first 250 characters of a Rich Text field value and does not include HTML markup. In v21.1+, use `RICHTEXT()` in the `SELECT` clause to retrieve the full value of a Rich Text field, including HTML markup.

All retrieval methods return newline characters.

## Syntax {#Syntax}

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

```

The `{field}` parameter must be the name of a Rich Text field.

## Query Examples {#Query_Examples}

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

### Query {#Query}

The following query retrieves the full value of this field with HTML markup:

```
SELECT name__v,
  RICHTEXT(rich_text_field__c) AS RichTextFunction
FROM campaign__c
WHERE name__v = 'Veepharm Marketing Campaign'

```

### Response {#Response}

```
{
"data": [
       {
           "name__v": "Veepharm Marketing Campaign",
           "RichTextFunction": "<blockquote><p style=\"text-align: left;\">A two-hour reduction in sleep per night for one week is associated with a significant reduction in psychomotor performance.</p></blockquote><p><br></p><p>Get a good night's sleep with <b>Veepharm</b>, clinically proven to help you fall asleep faster and stay asleep longer. Ask your doctor if <b>Veepharm&nbsp;</b>is right for you.</p>"
       }
   ]
}

```


---

**Previous:** [LONGTEXT()](/qualityone/vql/functions-options/longtext)  
**Next:** [State Functions](/qualityone/vql/functions-options/state-functions)