Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Wildcard

Status
Not open for further replies.
marcusmco

marcusmco

IS-IT--Management
Oct 9, 2006
30
AU
Hello,

I am trying the following in an expression for a textbox:

=IIf(Fields!FFOSV1.Value Like 'F20%' ,"bla bla","")

The value of FFOSV1 is F20 but it doesn't work. I get a syntax error. Does anyone know what I am doing wrong?

Cheers,
Marcus
 
Sort by date Sort by votes
I've never tried to use "Like", or maybe it's the single quotes...anyway...

You could try something like:

=IIF(left(Fields!FFOSV1.Value, 3) = "F20", "bla bla", "")

Hope this helps,
 
Upvote 0 Downvote
What a great workaround! Works perfectly fine. Thanks!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

aztech
  • Locked
  • Question
Using wildcards in filter expressions 1
Replies
3
Views
109
xlbo
xlbo

Part and Inventory Search

Sponsor

Back
Top