Yes, this is an Access table and I tried the trim. In datasheet view I see just MC63 in the field- no other characters. Other values in this field are acting normal (i.e. select id from table where id = "mc55")
In datasheet view, if I use the Find and put
Find What: MC63
Look In: ID
Match: Whole Field
it cannot find the value. If I use Match: Any Part of Field it can find MC 63.
Thanks,
Elizabeth
--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Dear glcass- (name?)
>
> If this is an Access table, there should not be any trailing blanks. You could
> try eliminating extraneous blanks by first running:
>
> UPDATE table SET ID = Trim([ID])
>
> After you do that, then id = "mc63" should work as long as it is an exact match.
>
> What do you see in the ID field when you do like "*mc63*" ??
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Kirkland, WA)
>
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of glcass58
> Sent: Wednesday, February 29, 2012 1:17 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] leading or trailing spaces/characters??
>
> 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!
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
Tidak ada komentar:
Posting Komentar