SQL search statement

[David M]

I am in the middle of creating a database search page for a web site...

I was wondering if an *(asterix) can be used as part of the LIKE section

i.e.

SELECT description, url, title FROM tblURL WHERE description =
* & txtsearchstring & *

would this filter out the selected fields that has the search string in the
"descrition" field....

any help would be appreciated

David M

[Matt]

I would suggest using the 'like' operand in your SQL statement:
SELECT description, url, title FROM tblURL WHERE description like
% & txtsearchstring & %

HTH ... Matt


"David M" <d_mcgillivray@lineone.net> wrote:
>
>I am in the middle of creating a database search page for a web site...
>
>I was wondering if an *(asterix) can be used as part of the LIKE section
>
>i.e.
>
>SELECT description, url, title FROM tblURL WHERE description =
>* & txtsearchstring & *
>
>would this filter out the selected fields that has the search string in
the
>"descrition" field....
>
>any help would be appreciated
>
>David M
>

[L. Howell]

"David M" <d_mcgillivray@lineone.net> wrote:
>
>I am in the middle of creating a database search page for a web site...
>
>I was wondering if an *(asterix) can be used as part of the LIKE section
>
>i.e.
>
>SELECT description, url, title FROM tblURL WHERE description =
>* & txtsearchstring & *
>
>would this filter out the selected fields that has the search string in
the
>"descrition" field....
>
>any help would be appreciated
>
>David M
>

David,

Nope, it does not like *'s it prefers % - hope this helps!

Leonard

[Bill]

"David M" <d_mcgillivray@lineone.net> wrote:
>
>I am in the middle of creating a database search page for a web site...
>
>I was wondering if an *(asterix) can be used as part of the LIKE section
>
>i.e.
>
>SELECT description, url, title FROM tblURL WHERE description =
>* & txtsearchstring & *
>
>would this filter out the selected fields that has the search string in
the
>"descrition" field....
>
>any help would be appreciated
>
>David M
>

I just experienced a similar problem myself. Try using % instead of *

Bill

[Don Wolthuis]

Bill is correct use %

"Bill" <Bill@neropes.com> wrote:
>
>"David M" <d_mcgillivray@lineone.net> wrote:
>>
>>I am in the middle of creating a database search page for a web site...
>>
>>I was wondering if an *(asterix) can be used as part of the LIKE section
>>
>>i.e.
>>
>>SELECT description, url, title FROM tblURL WHERE description =
>>* & txtsearchstring & *
>>
>>would this filter out the selected fields that has the search string in
>the
>>"descrition" field....
>>
>>any help would be appreciated
>>
>>David M
>>
>
>I just experienced a similar problem myself. Try using % instead of *
>
>Bill
>