Adding Value to Range Parameter

[noxum]

I'm searching off a name and only asking for the first letter. How could I add a * to the end of the field this is what I'm currently doing:

Left ({F0101.ABALPH},1 )= {?Enter First Letter}

Would like to add to the end of {?Enter First Letter} so I can pass this search pattern back to the server.

 

[pgtek]

Hi
Create a formula @Search
The following examples are applicable to both Basic and Crystal syntax:

{customer.FIRST NAME} like "D?n"

TRUE, where {customer.FIRST NAME} = Dan or Don.

{customer.FIRST NAME} like "D?n"

FALSE, where {customer.FIRST NAME} = Doug or Rob.

{customer.LAST NAME} like "*s?n*"

TRUE, where {customer.LAST NAME} = Johnson or Olson or Olsen.

{customer.LAST NAME} like "*s?n*"

FALSE, where {customer.LAST NAME} = Johnston or Smith.

Use this one
@Search
totext(left({F0101.ABALPH},1)) = "{?*}"

hope this helps

pgtek

 

[pgtek]

Use this one
@Search
{F0101.ABALPH} like "{?*}"

hope this helps

pgtek

 

[noxum]

The users enter the beginning letter from a RANGE parameter.(I've added a mask to add the * at the end of the letter) So everytime I put this statement:

{F0101.ABALPH} like {?Enter First Letter}

"A String is Required here" error comes.
How would I get this to work?