Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- with zips as (
- select id ,cast(replace(replace(left(ltrim(Zip_Code),5), '-', ''), char(32), '0') as int) as zip_clean
- from table1)
- select * from zips
- where zip_clean in
- (19116,
- 94595,
- 60062)
Add Comment
Please, Sign In to add comment