The wild cards are a question mark for one character, asterisk for multiple .
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??
What kind of database object are you using? table/view/stored procedure? Does the report work if you remove the not like statement?
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