Filter on first 3 characters

[Joe1010]

I would like to filter records where the first 3 characters start with xyz. What is the function for this?
Thanks

 

[lbass]

{table.field} startswith "xyz"

-LB

 

[synapsevampire]

Go to Report->Selection Formula->Record and place:

{table.field} startswith "xyz"

Or you might create flexibility by creating a parametere and referencing the parameter in a wildcard:

{table.field} like {?MyParameter} +"*"

Now the user can enter what they want it to search for.

-k

 

[Joe1010]

It works only for text fields. I would like to use this for a number field where order_no starts with 543
Thanks

 

[GJParker]

Cstr({table.field},0,'') like {?MyParameter} +"*"

beware that depending on your database this may not be passed as part of the generated SQL statement, so could be filtered locally and slow down teh report.

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[synapsevampire]

Create a SQL Expression which castc or converts it and then use the like pattern against the SQL Expression.

This will all be processed on the database.

-k