I have two columns:

* id (nchar)
* name (varchar)

Something simple just can't figure out how.

```
    select *
    from plant.carrier
    where carrier_id like 'NT'

```

This gives an expression error

```
      SELECT *
      FROM plant.carrier
      WHERE RTrim(CAST([carrier_id] As VarChar) = 'NT'

```

id column

![enter image description here](https://i.stack.imgur.com/muIsJ.png)

```
CREATE TABLE [plant].[carrier](
    [carrier_id] [nchar](4) NOT NULL,
    [name] [nvarchar](30) NOT NULL,
 CONSTRAINT [PK_carrier] PRIMARY KEY CLUSTERED 
(
    [carrier_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS =enter code here ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO

```