Return (display) only part of a field

[Brett]

Hello,

How would I go about in SQL - Access to display only part of a field
after a specific character?

For example,

In Invoice.Memo, there would be variations on the following:

"SO 3453. Serial # 243"

Basically, I would like to see any data in the memo field AFTER the
period (and this field would only have one period) returned in the
query (not the stuff before it).

Invoice.Memo Returns:
Serial #243

Thanks in advance,
Brett

[Allen Browne]

Re: Return (display) only part of a field

Answered in another group where you posted this same q.