About former_SQLA_member1694939

former_SQLA_member1694939

I'm attempting to write a query in SQL Anywhere 17 that uses the CONTAINS function and searches for a literal asterisk. I've used all the escape sequences I could find and none are working, they all return the error that an asterisk is prefix search...

former_SQLA_member1694939

We have a Vendor table, an Inventory table and a Worksheet table set up. The Inventory table has a column that stores the default vendor for an item, the worksheet table has a column that stores the vendor that is used on a particular order. I'm att...

former_SQLA_member1694939

Thanks for the deeper explanation, Volker. I ran the function and got the same results. What you're saying makes sense, although I'm still hoping someone will waltz along with a solution that works that doesn't require using an external term breake...

former_SQLA_member1694939

If it isn't possible to search for an asterisk it would be nice if the docs stated it explicitly. As Volker said, there is a lot of ambiguous language surrounding the issue.

former_SQLA_member1694939

Maybe I should have linked the the CONTAINS docs. I did look at them, but I don't see any answer forthcoming there either.

former_SQLA_member1694939

I updated the post to reflect that I tried that solution as well. Thanks again!

former_SQLA_member1694939

Thanks, Volker! '"*"' did not work, I once again got the prefix search only error.

User Statistics

User Activity

Using Contains to Select for Literal Asterisk

Joining the Same Table to Different Tables

Re: Using Contains to Select for Literal Asterisk

Re: Using Contains to Select for Literal Asterisk

Re: Using Contains to Select for Literal Asterisk

Re: Using Contains to Select for Literal Asterisk

Re: Using Contains to Select for Literal Asterisk