Quick point.....

The preferred method with SQL is to use the wildcard charcter of '%' to find all records, or records that begin with a specified string of characters. Also, the Like operator, as opposed to the = operator, provides much more flexbility and is more in line with the SQL world at large. The "" (space(0)) stuff is more of an xBase/Fox thing, not something that applies to the SQL world at large. Finally, using the latter methods, you don't need to worry about the setting of ANSI.


>If the parameter is character (i guess it's the case by name convention) then ou may keep SET ANSI OFF (it's default) and set lcCategory='' (SPACE(0)). This case SELECT-SQL (view) will pick-up all records.