Luis Sandoval
|
| Posted: 06/29/2004, 2:28 PM |
|
Hi there,
I have a problem every time I run my query. I do the following code and I still can't get the data from the field. Here is the query, I do a criteria Like "*Name*", and I get nothing.
can you please give an Idea.
Thank you so much
|
|
|
 |
Luis Sandoval
|
| Posted: 06/29/2004, 2:29 PM |
|
Quote Luis Sandoval:
Hi there,
I have a problem every time I run my query. I do the following code and I still can't get the data from the field. Here is the query, I do a criteria Like "*Name*", and I get nothing.
can you please give an Idea.
Thank you so much
Luis Sandoval
|
|
|
|
dhempy
Posts: 40
|
| Posted: 06/29/2004, 3:13 PM |
|
Quote Luis Sandoval:
Hi there,
I have a problem every time I run my query. I do the following code and I still can't get the data from the field. Here is the query, I do a criteria Like "*Name*", and I get nothing.
can you please give an Idea.
Thank you so much
I think you're trying to use * as a wildcard. In SQL , you'll want the % character as a multi-character wildcard.
Try this: like "%Name%"
That will find records where "Name" appears anywhere in the field, with optional stuff before or after it.
Hope this helps,
-dave
_________________
David Hempy
Director of Broadcast and Education Technology
Kentucky Educational Television
800-333-9764 |
 |
|
|
