OK, thanks for the feedback, I'll look to use a command instead, I've tried selecting using MS SQL and the logic to select everything where order number like '%*' works fine. Thanks again.
Thanks, lbass for the prompt reply, but could you just clarify the relevance of the ^ symbol in your formula above? I'm not quite sure of the context in which I should use your proposed formula
Hello - using Crystal 10 on MS SQL Server 2000 database
I have tried some of the tips in thread 767-1051284 but I think the key difference is I also want to use wildcards, as follows:
We have order numbers in the form 21064357 and 21064357* where the asterisk is part of the order number...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.