Is it possible to trim a field in a view

[nysouth]

The zip code in my database store zip codes as zip + 4 in one field, but there are some tables that I would need to link against just the zip without the + 4 extension. Is it possible create a view that will show only the first 5 numbers?

Any help is greatly appreciated.

Colleen
ccaban@alphaomicronpi.org

 

[JamesLean]

SELECT LEFT(zip, 5) AS zip
FROM tbl

--James

 

[nysouth]

That worked like a charm.

Thanks a bunch!
Colleen