# Column medicare.admissions.zip4

## Overview of column zip4 in table medicare.admissions 

|                               |                        |
| ----------------------------- | ---------------------- |
| Table                         | [medicare.admissions](../medicare.admissions.md)           |
| Qualified name                | medicare.admissions.zip4  |
| Datatype                      | INT        |
| Column type | copied |



## Expressions

```sql
SELECT zip
```


### Casts:

| Original type | Cast expression      |
| ------------- | -------------------- |
| numeric | (CASE WHEN {column_name} < 100000 THEN NULL ELSE ({column_name}%10000)::INT END) |
| character varying | (CASE WHEN LENGTH({column_name}) < 6 THEN NULL ELSE SUBSTRING({column_name} FROM 6 FOR 4)::INT END) |