**Source URL:** https://general.veevavault.dev/vql/operators/comparison-operators.md

# Comparison Operators



All comparison operators are available in all versions. You can use comparison operators in the [WHERE clause](/vql/clauses/where).

## Equal to (`=`) {#Equal_to}

```
SELECT id, user_name__v, security_profile__v
FROM users
WHERE user_locale__v = 'es_US'

```

## Not Equal to (`!=`) {#Not_Equal_to}

```
SELECT label__sys, due_date__sys
FROM active_workflow_task__sys
WHERE status__sys != 'available__sys'

```

## Less than (`<`) {#Less_than}

```
SELECT id, document_number__v
FROM documents
WHERE document_creation_date__v < '2016-04-23'

```

## Greater than (`>`) {#Greater_than}

```
SELECT id, site_status__v, location__v
FROM site__v
WHERE modified_date__v > '2016-04-23'

```

## Less than or Equal to (`<=`) {#Less_than_or_Equal_to}

```
SELECT id, document_number__v
FROM documents
WHERE version_modified_date__v <= '2016-04-23T07:30:00.000Z'

```


---

**Previous:** [Operators](/vql/operators)  
**Next:** [Logical Operators](/vql/operators/logical-operators)