[AccessDevelopers] Left string question

 

Hello all

I have a field that has a name field with the examples Below.

I would like to get rid of the & in the string. But I cannot find any Left to get rid of a character like an &.

Is there no way to get rid of that character?

Thank

Jim Wagner

Smith, John David & Mary Lynn
Jones, Frank & Cammie Deborah
Lee, Jim

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 3

Visit Your Group

Please zip all files prior to uploading to Files section.

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___