Re: comparing the first character in two different fields

From: Leslie (Leslie_at_discussions.microsoft.com)
Date: 06/29/04 

Date: Tue, 29 Jun 2004 07:50:02 -0700

I used (Left("ABIM GASTRO-94_97.[middle]",1)) and I only received the A's. 

-- 
Leslie - AGA
"Rick B" wrote:
> use...
> 
>  Left([SomeFieldName])
> 
> ....to get the first character.
> 
> 
> Rick B
> 
> 
> "Leslie" <Leslie@discussions.microsoft.com> wrote in message
> news:6C6B71D5-E8BB-40DD-96F6-955F9A90DE84@microsoft.com...
> I am trying to compare to middle name fields.  I need to match my records by
> F/M/L, however I have one middle name field that contains the initial and
> the other middle name field spells it out.  I need to match by the first
> character of the two middle names fields.
> 
> -- 
> Leslie - AGA
> 
> 
>

Relevant Pages