I thought about it, but could not find LIKE operator in HELP.

>>Hi everybody,
>>
>>In HELP I could not find LIKE operator. I see LIKE() function definition.
>>
>>I want to be able to search by phones without area code. I have field as cArea_Code+cExchange+cLast_Four.
>>
>>Here is my code:
>>

>>*---------------------- Location Section ------------------------
>>*   Library: 	Asearchcontrols.vcx
>>*   Class: 		Cntphonesearch
>>*   Method: 	Getwhereexpression()
>>*----------------------- Usage Section --------------------------
>>*)  Description:
>>*)
>>
>>*   Scope:      Public
>>*   Parameters:
>>*$  Usage:
>>*$
>>*   Returns:
>>*--------------------- Maintenance Section ----------------------
>>*   Change Log:
>>*       CREATED 	08/12/2005 - NN
>>*		MODIFIED
>>*----------------------------------------------------------------
>>LOCAL lcRetVal
>>lcRetVal = ""
>>DO case
>>	case NOT EMPTY(this.txtAreaCode.Value) AND NOT EMPTY(this.txtExchange.Value) AND NOT EMPTY(this.txtLastFour.Value)
>>		lcRetVal = SUBSTR(STRTRAN(this.cSeparator + this.cFldname, this.cSeparator, "+##ALIAS##."),2) ;
>>           + " LIKE '" + this.txtAreaCode.Value + this.txtExchange.Value + ;
>>           this.txtLastFour.Value  + "%'"
>>    case EMPTY(this.txtAreaCode.Value) AND NOT EMPTY(this.txtExchange.Value) AND NOT EMPTY(this.txtLastFour.Value)
>>		lcRetVal = SUBSTR(STRTRAN(this.cSeparator + this.cFldname, this.cSeparator, "+##ALIAS##."),2) ;
>>           + " LIKE '???" + this.txtExchange.Value + ;
>>           this.txtLastFour.Value  + "%'"
>>ENDCASE
>>
>>this.cWhereExp = STRTRAN(m.lcRetVal, "##ALIAS##", this.cAliasname)
>>
>>RETURN m.lcRetVal

>>
>>
>>If I put area code, it works. Without area code it immediately produces no records found message. What is wrong here? Can I combine ??? and % in one string?
>
>
>N,
>
>The ? for the sql LIKE is _ (underscore)