Calgary Query for a partial value

[mike_weaver]

I have a calgary table which includes a 10-digit phone number as a string field. I'm trying to allow a search on just a part of the phone number. The current language looks like this.

<And><Field name="Phone" value="DDPhoneNumber" type="begin" /></And>

This allows the user to put in just the area code and get correct results, but I can't put in a phone number without the area code. Is there a way to do that? (note: the field is not a full text field so the type cannot be "contains").

Thanks.

[MarqueeCrew · Accepted solution]

@mike_weaver,

Ideally, you'll create 2 additional phone fields with each phone itself.  Area Code & Phone.  Then you can easily search on those fields (you can create an index on them and not a data field for output) quickly. 

Sorry.

cheers,

Mark

[mike_weaver]

Thank you.