Post reply

"LIKE" syntax in SSRS

  • September 10, 2008 at 9:18 am

    #212547

    I'm trying to find out what the syntax in RS would be if I want to assign a value depending of the content of a text field as shown below:

    =Iif( Fields!CampaignID.Value like "RENEW*",

    "Accepted Renewal", "Agreed to Testimony")

    However I don't think RS works with operand "like".

    Is there a function in RS for 'like' or instring'?

    thx,

    John

  • September 10, 2008 at 9:53 am

    #869776

    There is a LIKE VB operator so you should be able to use that. Take a look here: http://msdn.microsoft.com/en-us/library/swf8kaxw(VS.71).aspx

    [font="Comic Sans MS"]toolman[/font]
    [font="Arial Narrow"]Numbers 6:24-26[/font]

  • September 10, 2008 at 10:21 am

    #869797

    Thx,

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply