[MS_AccessPros] Re: leading or trailing spaces/characters??

 

That returns 51.
Thanks

--- In MS_Access_Professionals@yahoogroups.com, "Graham Mandeno" <graham@...> wrote:
>
> ...and also:
>
> Asc(Right(ID,1))
>
> Best wishes
> Graham [Access MVP 1996-2012]
>
> > From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane
> > Sent: Thursday, 1 March 2012 11:38
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: [MS_AccessPros] Re: leading or trailing spaces/characters??
> >
> >  
> > What are the results from:
> >
> > Len(Trim(ID))
> >
> > Len(ID)
> >
> > Duane Hookom
> > MS Access MVP
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "glcass58" <glcass58@>
> wrote:
> > >
> > > I can't figure this out.
> > >
> > > select id from table where id = "mc63" does not work
> > > select id from table where id like "*mc63*" does
> > >
> > > I tried Trim([id]) and Replace([id]," ","") but they did not help.
> > >
> > > Any assistance would be greatly appreciated!
> > >
>

__._,_.___

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

Messages in this topic (8)

Recent Activity:

• New Members 8
• New Files 3

Visit Your Group

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

.

__,_._,___