Trim Whitespace From Text

Remove leading and trailing whitespace from string values with `TRIM`.

5/5 supported engines validation-green 1 example 2 scenarios

Docker-validated Not currently validation-green

Example 1

Remove spaces around a value

Leading and trailing spaces are removed before the value is returned.

Source table data Rows loaded before the example query runs.

Setup

CREATE TABLE inputs (raw_name VARCHAR(50));

INSERT INTO
  inputs (raw_name)
VALUES
  ('  Ada  ');

Validated query Shared across supported engines.

SQL

SELECT
  TRIM(raw_name) AS cleaned_name
FROM
  inputs;

Expected result Returned rows for the shared example.

cleaned_name
Ada

This `TRIM` example returns the same cleaned string across engines.

Useful when

Where this command helps.

cleaning imported text before comparisons
normalizing user-entered values that may include accidental spaces

Explanation

What the command is doing.

TRIM is useful when cleaning user input, imported text, or inconsistent source data. It removes whitespace around the edges of a string while leaving the internal text unchanged.

Trim Whitespace From Text

Remove spaces around a value

Where this command helps.

What the command is doing.

Keep moving through nearby tasks.