Not Like Operator

[LebronJames]

What is the syntax for Not Like in version 8.5? Please provide example..

 

[synapsevampire]

Try:

not({table.field} like "*some text*&quot

The wild cards are a question mark for one character, asterisk for multiple .

-k

 

[bdreed35]

not ({Credit.Credit Authorization Number} like "CR*&quot

~Brian

 

[LebronJames]

Thats what I have as the syntax,

Why am I getting Database Error Dialog box with the msg: ODBC error and when I click OK I get SQL server error??

 

[bdreed35]

What kind of database object are you using? table/view/stored procedure? Does the report work if you remove the not like statement?

~Brian

 

[kenhamady]

Actually, a better test would be "Does the report run if the formula is simply the field by itself". If you take out the formula, and that field is the only field from that table, then the SQL is completely different.

Post your formula and tell us if this is a selection formula or a formula field.



Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[synapsevampire]

Where are you putting this syntax?

It should be in Report->Edit Selection Formula->Record if you want to limit rows in the report.

-k