Matching a figure in a string 1

[rewob65]

I have a concatenated string say 0234067 show for instance 3 equals Wednesday when we visit. I am trying to selct the formaul by putting in 3 into the(?Day) field but cannot work out a formula to just return where 3 is in the string. The formula I have is below and in the example of 0234067 would return any with just 0234067. However I want any with just one number matching.

{@Concatenate} like {?Day}

I use 8.5

Thanks

 

[GJParker]

you could use

InStr({@concatenate},{?day}) <> 0

although if you are using this as part of the selection formula, this processing will be done locally rather than on the server.

HTH

Gary Parker
MIS Data Analyst
Manchester, England