Issue 1:
If you are using the * (Multiplication) character in the sub query under cBiz views, then cBiz will replace it as %. So don’t use the * in sub queries.
Issue 2:
In the cBiz Reports or Views we cannot use the
SQL ISNULL() function. To use it we have to say.
IsNullTSQL(WorkPhone,"xxx").
OR
Use The User Defend Function :
http://www.cbizsoft.com/techsupport/Downloads/IsCBONull.zip