Re: [MSAccessProfessionals] Stripping out a zipcode

Sorry I thought the back end is SQL server. It's not in Access.

On Fri, Aug 21, 2020 at 02:10 PM, Duane Hookom wrote:

I don’t believe PatIndex() is available in MS Access like it is in SQL server. 

 

Duane

Sent from my mobile

On Aug 21, 2020, at 12:46 PM, Wei Qian via groups.io <wei_qian2001=yahoo.com@groups.io> wrote:

You can use PatIndex() function to find the position of "-", then use left(), right(), or substring() to strip out zip code.  ~ Wei

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#115747) | Reply To Group | Reply To Sender | Mute This Topic | New Topic

Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_