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

 

Well, this is interesting! For the MC63 value, both returned 10. Why would that be?
Thanks,
Elizabeth

--- In MS_Access_Professionals@yahoogroups.com, "Duane" <duanehookom@...> wrote:
>
> 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 (6)

Recent Activity:

• New Members 8
• New Files 3

Visit Your Group

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

.

__,_._,___