Well, my client was trying to work it from the desktop.
I've never been an Access buff and couldn't even figure out how to set LIKE
'*foo*' from the desktop using query builder or whatever the hell Access
calls it.
best, paul
At 04:45 PM 3/3/01 -0600, you wrote:
> > -----Original Message-----
> > From: paul smith [mailto:[EMAIL PROTECTED]]
> > Sent: Saturday, March 03, 2001 11:32 AM
> >
> > Fellow Listers:
> >
> > Does Access allow SQL such as: "WHERE my_field LIKE '%foo%'" and my_field
> > is of Memo type?
>
>Yes.
>
> > (or does Access allow: "WHERE my_field LIKE '*foo*' " from the desktop)
> >
>
>Not sure, but I don't think so. Your questions could easily be answered by
>trying it though.
Easy for you, difficult for me ;-)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
