Here is what I do to solve this problem.
Create a table with a char 24 field named MyField.
Add a record with Append Blank.
In the command window:
? '' $ MyField && displays .F.
replace MyField with ''
? '' $ MyField && displays .F.
** If at first you don't succed ...
? empty(MyField) && displays .T.
? '' $ alltrim(MyField) && Holy cow! .F. again!
** ... live with it.
Now the question is why are you looking for ''?
If you are looking for empty field then try
? space(len(MyField)) $ MyField && displays .T.
or
? empty(MyFeld)
Good luck Steve.
>I am trying to build a Parameterized View, but I want to do a substring search with 3 parameters.
>
>If cUsrFirstChoice = 'Toolkit', then this works:
>
> where ?cUsrFirstChoice $ cTitle
>
>But if cUsrFirstChoice = 'Toolkit' and cUsrSecondChoice = ''
>then this returns no records:
>
> where ?cUsrFirstChoice $ cTitle
> and ?cUsrSecondChoice $ Subtitle
>
>I was dinkering with macro expansion and the '%' but am coming up dry. Help?!
A moment of silence is our cosmic reset button.