Ends With search on numeric characters

[ronnutter]

I'm searching on contract numbers on a report but there is no standard format how the contract numbers are entered.
examples:
01-0230
010230
SC01-0230

Is there a way to only search for contract numbers that
end with 0230?

thanks,
Ron

 

[dgillz]

For your report, you can select only those records that end in "0230" by putting a records selection formula of:
right({contractnumber},4}="0230"

Is this what you mean by "searching"? If not please post with a complete description of the problem. Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office

 

[chelseatech]

You could also use Like in a formula
{Contractnumber} like "*0230"
Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[Ngolem]

or a more general solution would be to create a Parameter say....called {?contract_extension} as a string in which the user can be prompted to enter the last digits of any contract number

then in the record select have a formula

{contractnumber} like "*" + {?contract_extension}

if this isn't pushed to the server because of being a formula...then just advise in your Parameter that the user should put a * before the contract extension value..then the record selection formula would be simply:

{contractnumber} like {?contract_extension}