how to use wildcard in a calculated field?

[BikeBoy]

Hi everyone,

Is it possible to use wildcard in a calculated field? What I mean is, instead of:

or

(Field A=1 and File B::Name="Dimitri") or

(Field A=1 and File B::Name="Dany") or

(Field A=1 and File B::Name="Daniel") or

(Field A=1 and File B::Name="Dan") or

(Field A=1 and File B::Name="Dimanuk") , 1, "")

Write something like:

Case(Field A=1 and File B::Name="D*", 1, "")

I know this is not the right syntax, but you get the idea. I want to use the wildcard like in search.

Thanks in advance

[Fenton]

If it's:

Case(Field A=1 and File B::Name="D*", 1, "")

then:

Case(Field A=1 and Left(File B::Name, 1) ="D", 1, "")

[BikeBoy]

Thanks so much, off course!

It's one of those "why didn't I think of it" deals. Thanks for lending me you brain!