[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 (4)

Recent Activity:

• New Members 9
• New Files 3

Visit Your Group

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

.

__,_._,___