ACCESS FEED: RE: [MS_AccessPros] What Query Builder Function do I Use to Find Equal Text Values

Sabtu, 01 Oktober 2011

RE: [MS_AccessPros] What Query Builder Function do I Use to Find Equal Text Values

Terry-

Clearly, one of the two values doesn't exactly equal the other. Is there a
blank at the end of the string in either table? LIKE should work as long as
you're comparing to the shorter string.

WHERE Table1.Column LIKE Table2.Column & "*"

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/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Terry Olsen
Sent: Saturday, October 01, 2011 6:15 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] What Query Builder Function do I Use to Find Equal Text
Values

Hi
I have two tables, each having a text column with this value
"P01_V0041_U0000.YC0". Using = returns nothing. Using Like returns more than I
need.
Is it possible to compare two text types?
Thanks
Terryomsn

------------------------------------

Yahoo! Groups Links