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