...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!
> >
Tidak ada komentar:
Posting Komentar